Install PostgresSQL in Ubuntu 12.04

Install the postgres software by

$ sudo apt-get install postgresql postgresql-contrib libpq-dev

Set up your password

Goto the postgres prompt

$ sudo -u postgres psql

Inside that you can set the password for the DB user postgres

ALTER USER postgres PASSWORD 'YourPassword';

References:
xtremekforever.blogspot
postgresql-password-authentication-failed-for-user-postgres

Advertisements

Author: Abhi

Hi, this is Abhilash - Senior Programmer Analyst at CoMakeIT, specialised on web programming. Mainly working on Ruby On Rails platform since 2010.

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