Re: pg_dump custom format and pigz

Поиск
Список
Период
Сортировка
От Tino Schwarze
Тема Re: pg_dump custom format and pigz
Дата
Msg-id 20091023131042.GA3252@easy2.in-chemnitz.de
обсуждение исходный текст
Ответ на pg_dump custom format and pigz  ("Marc Mamin" <M.Mamin@intershop.de>)
Ответы Re: pg_dump custom format and pigz  ("Marc Mamin" <M.Mamin@intershop.de>)
Список 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 по дате отправления:

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: pg_dump custom format and pigz
Следующее
От: "Marc Mamin"
Дата:
Сообщение: Re: pg_dump custom format and pigz