Re: Dump large DB and restore it after all.

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Dump large DB and restore it after all.
Дата
Msg-id 4E134C7F.7010408@fuzzy.cz
обсуждение исходный текст
Ответ на Re: Dump large DB and restore it after all.  (Condor <condor@stz-bg.com>)
Список pgsql-general
Dne 5.7.2011 13:31, Condor napsal(a):
> On Tue, 05 Jul 2011 18:08:21 +0800, Craig Ringer wrote:
>> On 5/07/2011 5:00 PM, Condor wrote:
>>> Hello ppl,
>>> can I ask how to dump large DB ?
>>
>> Same as a smaller database: using pg_dump . Why are you trying to
>> split your dumps into 1GB files? What does that gain you?
>>
>> Are you using some kind of old file system and operating system that
>> cannot handle files bigger than 2GB? If so, I'd be pretty worried
>> about running a database server on it.
>
> Well, I make pg_dump on ext3 fs and postgrex 8.x and 9 and sql file was
> truncated.

AFAIK the ext3 filesystem should handle at least 16GB files, depending
on the block size. And I don't think pg_dump truncates the file.

Tomas

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

Предыдущее
От: c k
Дата:
Сообщение: Python UCS4 error
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Dump large DB and restore it after all.