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