Re: pgdumpall_file is bigger than 2 Gigabyte

From: Andreas Hödle <hoedle(at)kwsoft(dot)de>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgdumpall_file is bigger than 2 Gigabyte
Date: 2001-12-07 16:47:43
Message-ID: 3C10F2AF.51673891@kwsoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"David M. Richter" schrieb:
>
> Hello!
>
> Ive got a problem!
> My database has the size of almost 5 Gigabytes.
> So the dump will take at least 2 Gigs of harddisk.
> But my Kernel supports only 2 Gig Files!
>
> Any experiences with big dumpfiles?
>
> Thanks a lot
>
> DAvid

Hello

I guess "split" and "gzip" are your friends. You can pipe the
"pgdumpall" to "split" with option to cut the file into pieces.
Recommended is to use also "gzip" or similar to compress the files.

Hope this helps

--
Andreas Hödle (Systemadministration)

Kühn & Weyh Software GmbH
Linnestr. 1-3
79110 Freiburg

WWW.KWSOFT.DE

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ross J. Reedstrom 2001-12-07 17:00:36 Re: pgdumpall_file is bigger than 2 Gigabyte
Previous Message David M. Richter 2001-12-07 16:07:43 pgdumpall_file is bigger than 2 Gigabyte