Installation postgresql 服务端

https://help.ubuntu.com/community/PostgreSQL 

1、

sudo apt-get install postgresql postgresql-contrib

2、

sudo -u postgres psql postgres

3、Set a password for the "postgres" database role using the command:

\password postgres

4、exit the posgreSQL prompt.

\q

5、Create database

sudo -u postgres createdb mydb