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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
