How to setup PostgreSQL

Jump to bottom Edit New page

Dmytro Yarmak edited this page Feb 4, 2014 · 3 revisions

➜ sudo apt-get install postgresql
➜ sudo -u postgres psql
postgres=# create role acdp with createdb login password 'asoiu';
postgres=# \q`

In file /etc/postgresql/9.1/main/pg_hba.conf change peer in line:

local   all             all                                     peer

to md5:

local   all             all                                     md5

and then restart postresql:

➜  sudo service postgresql restart