[Box Backup] boxbackup + pg_dump

Anton Bogdanovitch boxbackup@boxbackup.org
Sun, 07 Jun 2009 02:39:44 +0400


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.