Re: [ADMIN] pg_dump custom format and pigz

2009-10-24 Thread Marc Mamin
arze Sent: Friday, October 23, 2009 4:25 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_dump custom format and pigz 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_dum

Re: [ADMIN] pg_dump custom format and pigz

2009-10-23 Thread Tino Schwarze
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 mis

Re: [ADMIN] pg_dump custom format and pigz

2009-10-23 Thread Marc Mamin
f Tino Schwarze Sent: Friday, October 23, 2009 3:11 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_dump custom format and pigz 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

Re: [ADMIN] pg_dump custom format and pigz

2009-10-23 Thread Tino Schwarze
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 back

[ADMIN] pg_dump custom format and pigz

2009-10-23 Thread Marc Mamin
Hello, 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 i