"Mr. Dan" <bitsandbytes88@xxxxxxxxxxx> writes: > Is this 2003 advice still relevant with postgresql 8.1.0? Our b-tree > indexes corrupt pretty often on our production server running 8.1.0 and we > are grasping for a solution. Corrupt how --- what's the exact symptoms? The *first* bit of advice I'd give you is that you shouldn't be on 8.1.0 anymore. We don't make update releases just for amusement. However, whether this represents an already-fixed problem is impossible to tell with no details. (As for that 2003 discussion, that predates the availability of PITR. Now, you can use a plain tar backup ... as long as you've got WAL logs to go with it.) regards, tom lane
