Re: [GENERAL] Feature Request: bzip2 support in pg_dump, pg_restore

2010-08-13 Thread Tom Lane
Greg Smith writes: > Daniel Migowski wrote: >> A small investigation showed to me that bzip2 compressed sql files >> take only 60% of the space of gz compressed files. Since bzip2 is >> fairly common today, could one add an option to pg_dump and pg_restore >> supporting this compression type in

Re: [GENERAL] Feature Request: bzip2 support in pg_dump, pg_restore

2010-08-13 Thread Greg Smith
Daniel Migowski wrote: A small investigation showed to me that bzip2 compressed sql files take only 60% of the space of gz compressed files. Since bzip2 is fairly common today, could one add an option to pg_dump and pg_restore supporting this compression type in their custom format? Or do the

Re: [GENERAL] Feature Request: bzip2 support in pg_dump, pg_restore

2010-08-13 Thread Scott Ribe
pg_dumpall | bzip2 > mydump.txt.bz2 bunzip2 -kc mydump.txt.bz2 | bin/psql template1 -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http:

Re: [GENERAL] Feature Request: bzip2 support in pg_dump, pg_restore

2010-08-13 Thread Adrian von Bidder
Heyho! On Friday 13 August 2010 10.57:13 Daniel Migowski wrote: > A small investigation showed to me that bzip2 compressed sql files take > only 60% of the space of gz compressed files. But bzip2 is very slow. I think if there should be changes to the data compression, xz is probably the futur