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
Views: Raw Message | Whole Thread | Download 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


Browse pgsql-admin by date

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