Re: On-line backup

"Mr. Dan" <bitsandbytes88@hotmail.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