Re: pg_dump max file size exceeded

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: Rolf Luettecke <rolf(dot)luettecke(at)michael-telecom(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump max file size exceeded
Date: 2002-03-22 09:38:54
Message-ID: 20020322123725.O19587-100000@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 20 Mar 2002, Rolf Luettecke wrote:

RL> >"Fred Moyer" <fred(at)digicamp(dot)com> writes:
RL> > ran time pg_dump -c --verbose database > datafile.psql from the command
RL> > line and got a file size limit exceeded. datafile.psql stopped at 2 gigs.
RL> > any ideas how to exceed that limit?
RL>
RL> Workaround: Pipe output to gzip/bzip2, if compressed file size does not
RL> reach 2 GB limit, or cut output into 2GB-pieces.

... and if it's still does not fit, pipe it further into split(1) ;-)
[though I don't know whether this utility exists in standard Linux
distrib. In BSDs it does.]

Sincerely,
D.Marck [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck(at)rinet(dot)ru ***
------------------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Auri Mason 2002-03-22 17:26:59 unable to locate a valid checkpoint
Previous Message Jean-Michel POURE 2002-03-21 14:07:47 Re: which site i download postsql