AWS Postgres RDS – Dump Data into SQL Format

amazon-rdsawsdjangopg-dumppostgresql

My team has hosted a django project in AWS with a Postgres RDS instance. What is the proper way to get export the database into SQL or pg_dump?

Best Answer

There is an interesting thing in RDS postgresql. I had the same issue, normal pg_dump won't work. Use the below command

pg_dump -Fc -v -h [endpoint of instance] -U [master username] [database] > [database].dump

Refer link: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html

Related Question