Re: Invalid Page Header
От | Christopher A. Goodfellow |
---|---|
Тема | Re: Invalid Page Header |
Дата | |
Msg-id | 000501c643aa$1608bad0$060a640a@wks10 обсуждение исходный текст |
Ответ на | Re: Invalid Page Header (Michael Fuhr <mike@fuhr.org>) |
Ответы |
Re: Invalid Page Header
Re: Invalid Page Header |
Список | pgsql-novice |
I have read quite a bit in the archives and it seems the best way is to zero_damaged_pages. I did a search for zero_damaged_pages. Is it as simple as adding zero_damaged_pages to postgresql.conf and restarting the postmaster? Thank You, Christopher A. Goodfellow Corporate Director Tealuxe, Inc. Phone: 508-520-7887 Fax: 508-528-8999 Tea For All -----Original Message----- From: Michael Fuhr [mailto:mike@fuhr.org] Sent: Wednesday, March 08, 2006 6:18 PM To: Christopher A. Goodfellow Cc: Pgsql-Novice (E-mail) Subject: Re: [NOVICE] Invalid Page Header On Wed, Mar 08, 2006 at 10:39:37AM -0500, Christopher A. Goodfellow wrote: > I get an "Invalid page header in block 23 of storetransaction_tbl" error on > my table when running any kind of select. Something has corrupted part of your table. If you search the list archives for "Invalid page header" you'll find suggestions on how to find the bad block and view its contents as a hex or ASCII dump (which might or might not be interesting) and how to zero that block so the database can access the rest of the table without errors (a destructive process, so don't do it lightly). http://archives.postgresql.org/ -- Michael Fuhr
В списке pgsql-novice по дате отправления: