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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s