[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