| From: | Jyry Kuukkanen <jyry(at)neutech(dot)fi> |
|---|---|
| To: | Fred Moyer <fred(at)digicamp(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dump max file size exceeded |
| Date: | 2002-03-20 06:05:34 |
| Message-ID: | Pine.LNX.4.33L0.0203200756300.6883-100000@cyclone.neutech.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, 2002-03-19 at 16:39, Fred Moyer wrote:
> hey fellow pg'ers.
>
> ran time pg_dump -c --verbose database > datafile.psql from the command line
> and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> ideas how to exceed that limit?
>
> redhat 7.2, 2.4.9-31 kernel
> postgres 7.2
Hello Fred
Are you trying to dump over NFS? NFS has a 2G file size limit and AFAIK
there is no simple way to get around it.
Howver, you could compress you dump on the fly:
pg_dump -c --verbose database |gzip -c >datafile.psql.gz
or
pg_dump -c --verbose database | bzip2 -c >datafile.psql.bz2
(for better compression)
restoring:
zcat datafile.psql.gz | psql database
or
bzcat datafile.psql.gz | psql database
Cheers,
--Jyry
C:-( C:-/ C========8-O C8-/ C:-(
Kansainvälisten kisojen tulosteksteissä käytetään
kilpailijoiden nimiin äänestoainetta.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rasmus Mohr | 2002-03-20 09:19:32 | Failure loading TCL/u |
| Previous Message | Tom Lane | 2002-03-20 05:15:16 | Re: pg_dump max file size exceeded |