Re: HINT: Please REINDEX it?

On Thu, Mar 26, 2009 at 09:00:53AM +0100, Bjørn T Johansen wrote:
> ERROR: index "connect_idx" contains unexpected zero page at block 208
> HINT: Please REINDEX it.
>
> What does this mean?

It means something bad has happened to an index. If you're running
an old version of PG then you may be affected by a known bug or you
could have bad hardware. Did the computer have its power turned off
unexpectedly, as if things are set up right then this could affect
things.

I've just had a quick search and you seemed to be running 8.3.5 before,
there don't seem to be any index related changes since then so maybe
your hardware isn't doing what it's told to!

> And how do I reindex it?

Just type:

REINDEX connect_idx;

in psql.

--
Sam http://samason.me.uk/