
> I suppose it wouldn't be overly hard to have pg_dump/pg_dumpall do
> something similar to what postgres does with segments.  I haven't looked
> at it yet however, so I can't say for sure.
> 
I would not integrate such functionality into pg_dump, since it is not
necessary.
A good thing though would be a little HOWTO on splitting and/or compressing 
pg_dump output.

The principle is:

backup:
mkfifo tapepipe
( gzip --fast -c < tapepipe | split -b512m - database.dump.gz. ) &
pg_dump -f tapepipe regression
rm tapepipe

restore:
createdb regression
cat database.dump.gz.* | gzip -cd | psql regression

Instead of gzip you could use a faster compressor like lzop, but you get the
idea :-)

Andreas

Mon, 21 Jun 1999 09:46:51 +0200
Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
AW: [HACKERS] tables > 1 gig
> A good thing though would be a little HOWTO on splitting and/or 
> compressing pg_dump output.

I already snarfed the description from Hannu Krosing and have put it
into manage-ag.sgml (which I've not yet committed to the web site;
will do so soon).

                  - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Tue, 22 Jun 1999 05:52:20 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: AW: [HACKERS] tables > 1 gig