How can I export a Postgres database?

·Around 1 minute

Using pg_dump, which ships with the psql executable, it's a pretty simple progress 

pg_dump --dbname={{DBNAME}} --host={{HOST}} --port={{PORT}} --username={{USERNAME}} --password --format=c > {{NAME}}.dump
# The c in --format=c stands for custom
pg_dump --dbname={{DBNAME}} --host={{HOST}} --port={{PORT}} --username={{USERNAME}} --password --format=c > {{NAME}}.dump
# The c in --format=c stands for custom

If you're dumping to a directory archive format1, you can use -j to parallelize this operation ie; pg_dump -j 4.

Footnotes

  1. https://www.postgresql.org/docs/current/backup-dump.html#BACKUP-DUMP-LARGE ↩