utf9k

Something to think about: Has anyone seen my keys? I dropped them in here somewhere...

How can I export a Postgres database?

In which I remind myself how to export a Postgres database

· ,

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

bash
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.