Install postgresql

Type:

sudo apt-get -y install postgresql postgresql-contrib

Create a new user:

sudo su - postgres
createuser --superuser pia

Then change the pia password:

psql
\password pia

Additional documentation:

• Basic installation on Debian: wiki.debian.org/PostgreSql
• For Ubuntu, you can use: help.ubuntu.com/community/PostgreSQL