From: | Janning Vygen <vygen(at)planwerk6(dot)de> |
---|---|
To: | Jorge Sarmiento <jsarmiento(at)ccom(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: psql -f backup.out || file too big |
Date: | 2001-11-12 09:08:22 |
Message-ID: | 01111210082203.15290@janning |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Sarmiento | 2001-11-12 16:09:01 | Re: psql -f backup.out || file too big - SOLVED |
Previous Message | Chris Ryan | 2001-11-11 03:36:14 | Re: OT?: PGReplication project dead? |
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Fiol Bonnín | 2001-11-12 09:34:31 | Re: Storing a tree |
Previous Message | gravity | 2001-11-12 08:26:18 | Re: Storing a tree |
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-hackers | 2001-11-12 09:32:28 | replicate "sequence" using rserv |
Previous Message | Christopher Kings-Lynne | 2001-11-12 08:03:41 | Problem concating bpchar and varchar in 7.1.3 |