speeding up backup with -Fc -Z ?

From: FM <dist-list(at)LEXUM(dot)UMontreal(dot)CA>
To: Mailing List Postgres-Admin <pgsql-admin(at)postgresql(dot)org>
Subject: speeding up backup with -Fc -Z ?
Date: 2008-08-06 18:50:46
Message-ID: 4899F286.70509@lexum.umontreal.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
During our backup, we are using pg_dump (sql format if no LO) and then
gzip to compress the sql file.
I read that the "custom" format can also compress ( -Z option) the dump.
Does someone use the latest to dump/compress backups ? Could it be a
good way to speed up the backup ?

Regards,

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-08-07 03:37:29 Re: reindexdb dying with SIGPIPE on 8.2.5
Previous Message C K 2008-08-06 17:04:06 Managing connections