On Fri, 2007-01-05 at 16:19, Geoffrey wrote: > 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.
Yes, reindex might fix it. But more than likely there's a problem with your hardware somewhere, and it needs to be checked out carefully for problems. i.e. bad hard drive, memory, cpu, etc... ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
