Backing Up with pg_dump

pg_dump -h host -U user shop > shop.sql

pg_dump -d shop -f shop.sql

pg_dump -Fc -d shop -f shop.dump            # binary, compressed, parallel restore

pg_dump -Fd -j 8 -d shop -f /backups/shop.d  # parallel dump

pg_dump -Fp -d shop > shop.sql    # readable; restore with psql

pg_dump -Ft -d shop -f shop.tar

pg_dump -t public.orders -t public.customers -Fc shop > subset.dump

pg_dump -n app -n reporting -Fc shop > app.dump

pg_dump -T 'audit_*' -T 'temp_*' -Fc shop > shop.dump

pg_dump -N 'temp_*' -Fc shop > shop.dump

pg_dump --schema-only -Fc shop > schema.dump

pg_dump --data-only -Fc shop > data.dump

pg_dump -Fd -j 8 -Z 6 -d shop -f /backups/shop.d

pg_dumpall -f cluster.sql               # roles + tablespaces + all DBs (plain only)
pg_dumpall --globals-only -f globals.sql

pg_dumpall --roles-only -f roles.sql