Configuring Postgres Ubuntu

Following our previous post, we now explain how to access Postgres through the command line.

First a modification has to be made in the config files:

nano /etc/postgresql/9.1/main/pg_hba.conf

uncomment the line and put

local all username md5

Where username is the user you created

then restart:

sudo /etc/init.d/postgresql restart

now you will be able to access:

psql database_name username

and you will be requested to enter the password