For When You Can't Have The Real Thing
[ start | index | login ]
start > postgresql > invalid page header

invalid page header

Created by dave. Last edited by dave, 11 years and 361 days ago. Viewed 2,681 times. #1
[edit] [rdf]
labels
attachments
(25 April 2012)

Problem

Apr 25 04:01:17 cp pgsql[20043]: [61-1] ERROR:  XX001: invalid page header in block 22925 of relation \"last_start_pkey\"
Apr 25 04:01:17 cp pgsql[20043]: [61-3] STATEMENT:  UPDATE last_start SET value = \'2012-04-25 04:01:17.485000-04\', last_user = 0 WHERE name = \'reseller_support\'

Solution

hsphere=# REINDEX TABLE last_start;
no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:


snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt