Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4F1D7650173 for ; Wed, 6 Aug 2008 17:15:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06552-05 for ; Wed, 6 Aug 2008 17:15:09 -0300 (ADT) X-Greylist: delayed 01:24:21.947007 by SQLgrey-1.7.6 Received: from pruche.dit.umontreal.ca (pruche.dit.umontreal.ca [132.204.246.22]) by postgresql.org (Postfix) with ESMTP id A89C464FD42 for ; Wed, 6 Aug 2008 17:15:11 -0300 (ADT) Received: from gw-mail.lexum.umontreal.ca (gw-mail.lexum.umontreal.ca [132.204.136.52]) by pruche.dit.umontreal.ca (8.14.1/8.14.1) with ESMTP id m76IpDAt027465 for ; Wed, 6 Aug 2008 14:51:13 -0400 Received: from [192.168.4.171] (trieste.lan.lexum.pri [::ffff:192.168.4.171]) (AUTH: PLAIN mederyf, SSL: TLSv1/SSLv3,256bits,AES256-SHA) by gw-mail.lexum.umontreal.ca with esmtp; Wed, 06 Aug 2008 14:50:46 -0400 id 0002729A.4899F286.00006CF7 Message-ID: <4899F286.70509@lexum.umontreal.ca> Date: Wed, 06 Aug 2008 14:50:46 -0400 From: FM User-Agent: Thunderbird 2.0.0.16 (X11/20080715) MIME-Version: 1.0 To: Mailing List Postgres-Admin Subject: speeding up backup with -Fc -Z ? Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-NAI-Spam-Score: 0 X-NAI-Spam-Rules: 1 Rules triggered RV3076=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/25 X-Sequence-Number: 29870 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,