Geoffrey wrote:
We had a vacuum fail recently with the following error:
invalid page header in block 846 of relation "move_pkey"
Anyone have an idea what could cause this problem and what we need to do
to resolve it?
Running on Red Hat Enterprise 3, postgres 7.4.13
Regarding the issue above, is it possible that re-indexing the database
could resolve the problem, since the error is related to an index.
move_pkey is an index on field recid.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
