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: 4899F286.70509@lexum.umontreal.ca (view raw or flat)
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,


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-2014 The PostgreSQL Global Development Group