Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Joshua D. Drake"
Date:
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.

   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.
Basically I am using the 7.2.3 version of pg_dump to pull a dump from
the 7.1.3 machine.

   Anybody got any ideas?

Sincerley,

Joshua Drake


--
<COMPANY>CommandPrompt    - http://www.commandprompt.com    </COMPANY>
<CONTACT>       <PHONE>+1.503.222-2783</PHONE>          </CONTACT>

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

From
Alvaro Herrera
Date:
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"

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

From
Tom Lane
Date:
"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

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

From
Mark Kirkwood
Date:
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