Re: psql -f backup.out || file too big

Am Samstag, 10. November 2001 02:52 schrieb Jorge Sarmiento:

> I am trying to restore a 2.5 Gb. backup file made using pg_dumpall,
> and I get the "file too big" error message from postgres

Its not a bug in postgres i guess. your filesystem reports an error.
You can use a zip utility like gzip. Just pipe your dump to your
favorite zip programm and zip it on the fly before you write it to
your dump_file.

if it´s still to big use 'split' to split your dump over various
files.

It´s documented in Chapter 8:  8.1.3 Large Databases in "Practical
PostgreSQL" It is not printed yet i think, but its available online.

I can send you a copy of this page per PM if you like.

Janning


--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de