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

Advertisement

Author: Abhilash

I'm Abhilash, a web developer who specializes in Ruby development. With years of experience working with various frameworks like Rails, Angular, Sinatra, Laravel, NodeJS, React and more, I am passionate about building robust and scalable web applications. Since 2010, I have been honing my skills and expertise in the Ruby on Rails platform. This blog is dedicated to sharing my knowledge and experience on topics related to Ruby, Ruby on Rails, and other subjects that I have worked with throughout my career. Join me on this journey to explore the exciting world of web development!

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 )

Connecting to %s

%d bloggers like this: