Re: pgdumpall_file is bigger than 2 Gigabyte

Поиск
Список
Период
Сортировка
От Andreas Hödle
Тема Re: pgdumpall_file is bigger than 2 Gigabyte
Дата
Msg-id 3C10F2AF.51673891@kwsoft.de
обсуждение исходный текст
Ответ на pgdumpall_file is bigger than 2 Gigabyte  ("David M. Richter" <d.richter@dkfz.de>)
Ответы Re: pgdumpall_file is bigger than 2 Gigabyte  ("Florian Helmberger" <f.helmberger@uptime.at>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ligia Pimentel"
Дата:
Сообщение: How to rename a database
Следующее
От: Steven Lane
Дата:
Сообщение: Shared memory oddity