Re: pg_dump max file size exceeded

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Fred Moyer" <fred(at)digicamp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump max file size exceeded
Date: 2002-03-20 15:45:43
Message-ID: 4.2.2.20020320084356.00b05460@ecint.ecinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

At 12:15 AM 3/20/02 -0500, Tom Lane wrote:
>"Fred Moyer" <fred(at)digicamp(dot)com> writes:
> > ran time pg_dump -c --verbose database > datafile.psql from the command
> line
> > and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> > ideas how to exceed that limit?
>
> > redhat 7.2, 2.4.9-31 kernel
>
>[ scratches head... ] If you were on Solaris or HPUX I'd tell you to
>recompile with 64-bit file offset support enabled. But I kinda thought
>this was standard equipment on recent Linux versions. Anyone know the
>magic incantation for large-file support on Linux?

depending on the shell being used, i'd try limit or ulimit

We've seen a case where large file support had to be tweaked in the Veritas
file systems as well.

--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Corey W. Gibbs 2002-03-20 16:35:21 Re: pg_dump max file size exceeded
Previous Message Andreas Scherbaum 2002-03-20 13:59:44 Re: sql by length of data