"Will Lewis" <will_lewis@xxxxxxxxxxxxxxxxxxx> 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
