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? -- Rafael Martinez, <[EMAIL PROTECTED]> Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/
signature.asc
Description: This is a digitally signed message part