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@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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
