aws-mon-pgsql
aws-mon-pgsql copied to clipboard
Unable to authenticate to the database
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.