"Will Lewis" <will_lewis(at)bristol-city(dot)gov(dot)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