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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
