Re: large database: problems with pg_dump and pg_restore

Поиск
Список
Период
Сортировка
От lst_hoe02@kwsoft.de
Тема Re: large database: problems with pg_dump and pg_restore
Дата
Msg-id 20101026213147.1040158mc9k2bgyo@webmail.kwsoft.de
обсуждение исходный текст
Ответ на large database: problems with pg_dump and pg_restore  (Martin Povolny <martin.povolny@solnet.cz>)
Список pgsql-admin
Zitat von Martin Povolny <martin.povolny@solnet.cz>:

> Hallo,
>
> I have some quite grave problems with dumping and restoring large
> databases (>4GB of
> dump).
>
> I had 5 databases, 4 dumped ok, the 5th, the largest failed dumping:
> I was unable to
> make a dump in the default 'tar' format. I got this message:
>
> pg_dump: [tar archiver] archive member too large for tar format

It looks like "tar" is limited to 4GB on your OS...

Try to use "split" to split up the dump to something which your
OS/Tools can reliable handle.

Regards

Andreas


Вложения

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

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: postgres 8.4.5 jdbc is 8.4-701.jdbc3
Следующее
От: Samuel Stearns
Дата:
Сообщение: Re: large database: problems with pg_dump and pg_restore