2 gig file limit (yes I know, read anyway ;))

On Tue, Dec 17, 2002 at 05:35:24PM -0800, Joshua D. Drake wrote:

Hello,

We are having a very odd problem. We have a PostgreSQL 7.1.3 system
that we are upgrading to 7.2.3. The 7.1.3 system is running RedHat 7.2.
As we run pg_dump we are hitting the old 2gig file limit size (and know
gzipping doesn't work because of the blobs).

I know why we are running into the 2gig limit. It is because the
system was upgraded from 6.2 and the 7.1.3 installation was not recompiled.

Why don't you pass the output of pg_dump through split(1) ?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"God is real, unless declared as int"

"Joshua D. Drake" <jd@commandprompt.com> writes:

However, when testing on RedHat 8.0 (Fresh Install) with a newly
compiled version of 7.2.3 we get the same file size limit errors.

If your platform requires an explicit switch to enable 64-bit filesize
then a standard 7.2.* build won't select that switch. 7.3 is supposed
to do so however ...

regards, tom lane

Joshua D. Drake wrote:

Hello,

We are having a very odd problem. We have a PostgreSQL 7.1.3 system
that we are upgrading to 7.2.3. The 7.1.3 system is running RedHat 7.2.
As we run pg_dump we are hitting the old 2gig file limit size (and
know gzipping doesn't work because of the blobs).

Joshua Drake

I would try rebuilding your 7.2.3, but export
CFLAGS="-O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64"
before running configure

regards

Mark