Re: pgdumpall_file is bigger than 2 Gigabyte - Mailing list 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