Re: Dump large DB and restore it after all.

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