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?
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