| From: | Carlo Curatolo <genamiga(at)brutele(dot)be> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Invalid Page Header Error |
| Date: | 2013-10-16 08:11:26 |
| Message-ID: | 1381911086555-5774724.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks for the help.
SELECT oid, relname, relkind FROM pg_class WHERE relfilenode = 599662; -->
returns nothing.
No crash occurs, I have tested the hardware (memory, harddisks, RAID5,
stability test...)
I have made a little program to read all the LargeObject of my tables, they
are all readable.
So, I restart postgreSQL with "zero_damaged_pages = on", lauch a vacuumlo
and vacummdb, restart with "zero_damaged_pages = off", the recheck all the
LargeObject of my tables.
The error do no occurs anymore...
Seems that the corrupted LargeObject was not used...possible ?
Regards.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Invalid-Page-Header-Error-tp1925403p5774724.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-10-16 09:32:16 | Re: Invalid Page Header Error |
| Previous Message | Albe Laurenz | 2013-10-16 07:55:21 | Re: Invalid Page Header Error |