"Mr. Dan" <bitsandbytes88(at)hotmail(dot)com> 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