Re: pg_dump large-file support > 16GB - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump large-file support > 16GB
Date
Msg-id 19680.1111418174@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump large-file support > 16GB  (Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no>)
List pgsql-general
Rafael Martinez Guerrero <r.m.guerrero@usit.uio.no> writes:
> Do you use any spesial option when you compile pg_dump, or in the
> program that could influence how the program behaves and can help me to
> reproduce the problem?

In a Linux system we'll add "-D_GNU_SOURCE" to the compile command line.
Also, pg_config.h sets some #define's that might affect things,
particularly "#define _FILE_OFFSET_BITS 64".  I see you did both of
those in your test, but you might want to review pg_config.h to see if
anything else looks promising.

Another line of thought is that there is something broken about the
particular build of Postgres that you are using (eg it was affected by a
compiler bug).  You might try building from source, or grabbing the src
RPM and rebuilding from that, and confirming the bug is still there ---
and if so, back off the CFLAGS to minimal optimization and see if it
changes.

            regards, tom lane

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: no IF - am I missing something ?
Next
From: Michael Ben-Nes
Date:
Subject: Re: Installing PostgreSQL in Debian