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

Re: pg_dump custom format and pigz

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump custom format and pigz
Date: 2009-10-23 13:10:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi Marc,

On Fri, Oct 23, 2009 at 02:48:58PM +0200, Marc Mamin wrote:

> I'm using pg_dump intensively, and until now using the plaintext format
> which allows me to pipe the output to pigz (
> This is the fastest way I've found to generate compressed backups.
> (These backups are very rarely used)
> I would like to switch to the custom format in order to take advantage
> of the parallel restore enhancement, but this would force me to give
> pigz up, hence loosing performances with pg_dump.

> Is there a way to combine the custom format with pigz?

You might add pigz as a post-processing step and disabling compression in



"What we nourish flourishes." - "Was wir nähren erblüht."

In response to


pgsql-admin by date

Next:From: Marc MaminDate: 2009-10-23 13:52:16
Subject: Re: pg_dump custom format and pigz
Previous:From: Marc MaminDate: 2009-10-23 12:48:58
Subject: pg_dump custom format and pigz

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