moomindani / aws-mon-pgsql Goto Github PK

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.