<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><table style="text-align: center; line-height: 1em; margin: 0.5em auto;" border="0" cellspacing="0" cellpadding="0" class="mce-item-table"><tbody><tr><td style="border-bottom: 1px solid #aaaaaa; padding: 0.4em 1em; border-top: 1px solid #555555;"><table style="text-align: center; line-height: 1em; margin: 0.5em auto;" border="0" cellspacing="0" cellpadding="0" bgcolor="#5c99dc" class="mce-item-table"><tbody><tr><td style="border-bottom: 1px solid #aaaaaa; padding: 0.4em 1em; border-top: 1px solid #555555;"><table style="text-align: center; line-height: 1em; margin: 0.5em auto;" border="0" cellspacing="0" cellpadding="0" class="mce-item-table"><tbody><tr bgcolor="#ffffff"><td style="border-bottom: 1px solid #aaaaaa; padding: 0.4em 1em; border-top: 1px solid #555555;"><table style="text-align: left; line-height: 1em; margin: 0.5em auto;" border="0" cellspacing="0" cellpadding="0" class="mce-item-table"><tbody><tr><td style="text-align: left; border-bottom: 1px solid #555555; padding: 0.4em 1em; border-top: 1px solid #555555;"><div class="bodyclass"><div>> Hm, I'd like to know more about that corruption. Did you report it when</div><div>> it occured?</div><div><br></div><div>Thanks Andres for explanations. I didn't reported the corruption when it</div><div>occured as it was my fault, not a PG bug, as the main cause was that I was using<span style="background-color: transparent;"> network drive, knowingly it's unreliable for DB but management didn't</span></div><div>believe me.</div><div>I had these kind of errors:</div><div>pg_dump emet_istina -F c -n usr_...</div><div>pg_dump: schema with OID 308991 does not exist</div><div>\dt+ pg_temp*.*</div><div>ERROR:  catalog is missing 1 attribute(s) for relid 5733555</div><div>drop schema pg_temp_9;</div><div>ERROR:  cache lookup failed for relation 5733715</div><div>drop schema pg_temp_6;</div><div>ERROR:  cannot drop schema pg_temp_6 because other objects depend on it</div><div>DETAIL:  table pg_temp_6.cur_dde000_105577 depends on schema pg_temp_6</div><div>HINT:  Use DROP ... CASCADE to drop the dependent objects too.</div><div>I had to manualy remove/edit records from pg_class, pg_type, pg_namespace,</div><div>pg_depend, pg_shdepend.</div><div>I finaly managed to make it works and could dump everything and rebuild the</div><div>DB for more security. Server was down for 1 week, and that event gave me</div><div>proven arguments to have local storage. That was with 9.6 and I took the opportunity<span style="background-color: transparent;"> to upgrade to 10.3 at the same time.</span></div><div>Now it's more clear it's a PG9/10/12 (I didn't tried 11) problem with</div><div>vacuum/autovacuum not changing xid on temp tables. So, as long a temp table</div><div>exists, it take age and finish by causing a wraparound protection.</div><div>Thierry</div></div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></body></html>