Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 ?


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group