AWS Postgres RDS dumping data into sql format

Question

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?

• Craig Ringer: Use pg_dump. I don't understand the problem.

Answer 1

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

• András Váczi: What does 'won't work' mean? Also, 'normal'?
• TheDataGuy: Pg_dump -h endpoint -d db -u user > back.sql this command won't work for RDS, it'll trigger some errors while restoring the db