Re: 2 gig file limit (yes I know, read anyway ;)) - Mailing list pgsql-general

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