Re: Fwd: Question: 2 GB file limit on linux

we are using 7.4 with more than 2G and dump restore works fine (suse
9).of course that does not mean it will work fine for you...
evgeny
Tom Lane wrote:
> "Will Lewis" <will_lewis@bristol-city.gov.uk> writes:
>
>>I saw a reference somewhere to a 2GB file limit when backing up Postgres da=
>>tabases on Linux. I can't remember where I saw it but our database is neari=
>>ng 2 GB in size and concerns are creeping in.
>>We are running Postgres 7.4 on Redhat AS4.
>>Is this still a problem or has this been resolved on this version of Linux?
>
>
> It probably works, but if you're worried you should test it directly.
> Create a scratch database, load a few GB of data, see if the backup and
> restore procedures you are currently using choke.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster