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

Unknown's avatar

Author: Abhilash

Hi, I’m Abhilash! A seasoned web developer with 15 years of experience specializing in Ruby and Ruby on Rails. Since 2010, I’ve built scalable, robust web applications and worked with frameworks like Angular, Sinatra, Laravel, Node.js, Vue and React. Passionate about clean, maintainable code and continuous learning, I share insights, tutorials, and experiences here. Let’s explore the ever-evolving world of web development together!

Leave a comment