Backup Postgresql database using pg_dump?

2

This worked for me.

PGPASSWORD=<YOUR_DB_PASS> pg_dump \
  -h postgres.render.com \
  -U <YOUR_DB_USER> \
  --format=custom --no-acl --no-owner \
  <YOUR_DB_NAME> > <YOUR_DUMP_NAME>.dump
2 Likes