Re: pg_dump large-file support > 16GB

On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
<r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> 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?
>

Have you tried piping the dump through split so that each file's size
is limited?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org