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

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: 2 gig file limit (yes I know, read anyway ;))
Date: 2002-12-18 09:17:20
Message-ID: 3E003D20.4060207@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2002-12-18 11:00:55 Re: INDEX suggestion needed
Previous Message Jean-Christian Imbeault 2002-12-18 06:59:04 Re: datetime