Fast PostgreSQL backups

Last updated: about 2 months ago

Published: 3 months ago

raw source | baked source

kbpostgresql

Sourced from: https://stackoverflow.com/questions/15692508/a-faster-way-to-copy-a-postgresql-database-or-the-best-way

1pg_dump -Fc -j 8 -Z 9  --file=file.dump myDb
  • Fc - use pg_restore archive format
  • j - jobs
  • Z - compression level, 0..9
Comments (0)
Add a comment