From: | Michael Kleiser <mkl(at)webde-ag(dot)de> |
---|---|
To: | Rafael Martinez Guerrero <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump large-file support > 16GB |
Date: | 2005-03-17 14:05:00 |
Message-ID: | 42398E8C.10807@webde-ag.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I found on http://www.madeasy.de/7/ext2.htm (in german)
ext2 can't have bigger files than 16GB if blocksize is 1k.
Ext3 is ext2 with journaling.
Rafael Martinez Guerrero wrote:
>Hello
>
>We are having problems with pg_dump.
>
>We are trying to dump a 30GB+ database using pg_dump with the --file
>option. In the beginning everything works fine, pg_dump runs and we get
>a dumpfile. But when this file becomes 16GB it disappears from the
>filesystem, pg_dump continues working without giving an error until it
>finnish (even when the file does not exist)(The filesystem has free
>space).
>
>I can generate without problems files bigger than 16GB with other
>programs.
>
>Some information:
>---------------------------
>OS: Red Hat Enterprise Linux WS release 3 (Taroon Update 4)
>Kernel: 2.4.21-27.0.2.ELsmp #1 SMP i686
>PG: 7.4.7
>
>LVM version 1.0.8-2(26/05/2004)
>EXT3 FS 2.4-0.9.19, 19 August 2002 on lvm(58,6), internal journal
>EXT3-fs: mounted filesystem with ordered data mode.
>----------------------------
>
>Any ideas? It looks like pg_dump has a limit of 16GB? How can we solve
>this?
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Lonni J Friedman | 2005-03-17 14:09:09 | Re: pg_dump large-file support > 16GB |
Previous Message | Rafael Martinez Guerrero | 2005-03-17 13:05:35 | pg_dump large-file support > 16GB |