On Thu, 26 Mar 2009 15:32:46 +0000 Sam Mason <sam@xxxxxxxxxxxxx> wrote: > 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. Not any power problem but had a disk problem; guess that might be the cause... > > 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! Almost correct... I am running 8.3.6 now... :) > > > And how do I reindex it? > > Just type: > > REINDEX connect_idx; > > in psql. > Thx, did that and now the error message is gone... BTJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
