Carlo Curatolo wrote: > SELECT oid, relname, relkind FROM pg_class WHERE relfilenode = 599662; --> > returns nothing. Maybe the wrong database? Try to find out which object this file belongs to (maybe with oid2name). > No crash occurs, I have tested the hardware (memory, harddisks, RAID5, > stability test...) Good. > I have made a little program to read all the LargeObject of my tables, they > are all readable. Good. > 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. You mean, you ran pg_dumpall, created a new cluster and imported, right? If you continue running the damaged cluster, the next problem is waiting just around the bend. > The error do no occurs anymore... > > Seems that the corrupted LargeObject was not used...possible ? I maintain that it was a table or index that was corrupted, not a large object. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
