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

Re: pg_dump max file size exceeded

From: Rolf Luettecke <rolf(dot)luettecke(at)michael-telecom(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump max file size exceeded
Date: 2002-03-20 17:47:03
Message-ID: 20020320184703.15733f21.rolf.luettecke@michael-telecom.de (view raw or flat)
Thread:
Lists: pgsql-admin
>"Fred Moyer" <fred(at)digicamp(dot)com> writes:
> 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?

Workaround: Pipe output to gzip/bzip2, if compressed file size does not
reach 2 GB limit, or cut output into 2GB-pieces.

Regards
R. Luettecke

In response to

Responses

pgsql-admin by date

Next:From: Jodi KanterDate: 2002-03-20 19:18:41
Subject: slow inserts
Previous:From: Shawn TagsethDate: 2002-03-20 17:09:31
Subject: Re: Failure loading TCL/u

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