I have a PostgreSQL database on an Amazon RDS instance.
I want to have a local dump of this instance.
So far, I've tried with this:
PGPASSWORD="Password" pg_dump -h mydb.xxxxxx.us-east-1.rds.amazonaws.com -p 5432
But it keeps throwing an error, saying that the server refuse the connection, and check if the server is actually running on port 5432
, which is actually doing.
All my credentials and DB path/codes are correct.
psql
using those parameters?