| From: | Carlo Curatolo <genamiga(at)brutele(dot)be> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Invalid Page Header Error |
| Date: | 2013-10-15 20:21:32 |
| Message-ID: | 1381868492389-5774671.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have quite the same problem.
When I lauch a vacuumdb, I have an error : ERREUR: en-tête de page invalide
dans le bloc 39639 de la relation base/16384/599662
With a
SELECT * FROM pg_catalog.pg_largeobject
Result is
ERREUR: en-tête de page invalide dans le bloc 39639 de la relation
base/16384/599662
I suppose that the data of LargeObject 599662 are corrupted...
Question is : How I could I know where this LargeObject is used ?
I can, of course, use the "zero_damaged_pages = on" option in
postgresql.conf. Then dump/restore.
But in this case I didn't know where this corrupted LargeObject is used...
If you have an idea...
Thank you in advance.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Invalid-Page-Header-Error-tp1925403p5774671.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2013-10-15 20:22:57 | Re: recursive query returning extra rows in 8.4 |
| Previous Message | Shaun Thomas | 2013-10-15 19:18:29 | Re: can you do rollback in a trigger function? |