[Box Backup] boxbackup + pg_dump
Anton Bogdanovitch
boxbackup at boxbackup.org
Sat Jun 6 23:39:44 BST 2009
Hi,
What is the best way to prepare weekly postgres dump for bbackupd upload?
Do I need to compress the dump?
1) pg_dumpall > dump.sql (then upload dump.sql)
2) pg_dumpall > dump.sql | pg_dumpall > dump.gz (then upload dump.gz)
What should I choose in order to get minimum amount of network bandwith
usage and to save backup storage space?
Thanks.
More information about the Boxbackup
mailing list