Re: pg_dump custom format and pigz - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: pg_dump custom format and pigz
Date
Msg-id 20091023131042.GA3252@easy2.in-chemnitz.de
Whole thread Raw
In response to pg_dump custom format and pigz  ("Marc Mamin" <M.Mamin@intershop.de>)
Responses Re: pg_dump custom format and pigz  ("Marc Mamin" <M.Mamin@intershop.de>)
List 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 (http://zlib.net/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
pg_dump.

HTH,

Tino.

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

www.lichtkreis-chemnitz.de
www.tisc.de

pgsql-admin by date:

Previous
From: "Marc Mamin"
Date:
Subject: pg_dump custom format and pigz
Next
From: "Marc Mamin"
Date:
Subject: Re: pg_dump custom format and pigz