Re: pg_dump custom format and pigz

Поиск
Список
Период
Сортировка
От Tino Schwarze
Тема Re: pg_dump custom format and pigz
Дата
Msg-id 20091023142525.GB3252@easy2.in-chemnitz.de
обсуждение исходный текст
Ответ на Re: 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 03:52:16PM +0200, Marc Mamin wrote:

> > You might add pigz as a post-processing step and disabling compression in pg_dump.
>
> The problem with this solution is that it make it necessary to
> decompress the dump entirely before using pg_restore (or did I miss a
> point ?)
> This is an issue as our uncompressed dumps may reach 3-500 GB...

Right, that would not work.

> A better way would be to have a configuration option to tell which
> compression tool should be used internally by pg_dump.

Well, that would mean linking pg_dump with the library providing the
compression you want. I suppose, only data is compressed, not the whole
dump, e.g. dumping without compression then compressing is different
from dumping with compression.

Tino.

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

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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: Re: pg_dump custom format and pigz
Следующее
От: Lewis Kapell
Дата:
Сообщение: Re: Increasing the length of a VARCHAR column without table rewrite