Re: pg_dump max file size exceeded - Mailing list pgsql-admin

From Naomi Walker
Subject Re: pg_dump max file size exceeded
Date
Msg-id 4.2.2.20020320084356.00b05460@ecint.ecinet.com
Whole thread Raw
In response to Re: pg_dump max file size exceeded  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump max file size exceeded
List pgsql-admin
At 12:15 AM 3/20/02 -0500, Tom Lane wrote:
>"Fred Moyer" <fred@digicamp.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


pgsql-admin by date:

Previous
From: Andreas Scherbaum
Date:
Subject: Re: sql by length of data
Next
From: "Corey W. Gibbs"
Date:
Subject: Re: pg_dump max file size exceeded