Dealing with postgres corruption

It can happen that a postgres backup using pg_dump (or pg_dumpall) fails with a message like: pg_dump: schema with OID 849375 does not exist This can once in a while when data is not flushed properly between the transaction logs and the filesystem. The only way to solve them (after making a file level backup, for the just in case situations) is to search and delete the offending OID from the database....

<span title='2013-10-05 19:40:00 +0000 UTC'>October 5, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;177 words&nbsp;·&nbsp;wouter