Skip site navigation (1) Skip section navigation (2)

Re: pg_dump max file size exceeded

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 (view raw or flat)
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.



In response to

pgsql-admin by date

Next:From: Rasmus MohrDate: 2002-03-20 09:19:32
Subject: Failure loading TCL/u
Previous:From: Tom LaneDate: 2002-03-20 05:15:16
Subject: Re: pg_dump max file size exceeded

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group