Обсуждение: 2 gig file limit (yes I know, read anyway ;))

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>

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