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
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!
View all posts by Abhilash