aws-mon-pgsql icon indicating copy to clipboard operation
aws-mon-pgsql copied to clipboard

Unable to authenticate to the database

Open ShadySQL opened this issue 9 years ago • 0 comments

Hey! This is great stuff. I have a small issue that I ran into and dont know what I am doing wrong. Upon running command:

echo "xxxxxxxx.cqa8xxbod34g.eu-west-1.rds.amazonaws.com:5432:postgres:postgres:password" > ~/.pgpass (of course it has the instance of my PG RDS DB)

chmod 600 ~/.pgpass

Then right after I run any command but receive the error: psql: FATAL: password authentication failed for user "postgres" FATAL: password authentication failed for user "postgres" password retrieved from file "/root/.pgpass" session_wait:

and I quit dont know how I am suppose to run this script or how to edit the file .pgpass to enable authentication to the RDS Instance. Any suggestions would be useful.

ShadySQL avatar Apr 28 '15 06:04 ShadySQL