Thread: Help pg_dump: failed sanity check

Help pg_dump: failed sanity check

From
"Dr. Nisai Wanakule"
Date:
In an attemp to move to 6.5.1 I did pg_dumpall an get the following message:

postgres@lagrange:pgsql 23$ pg_dumpall >/opt3/db.out
failed sanity check,  type with oid 227715 was not found
pg_dump failed on oropdata, exiting

How can I go about to fix the problem for a successful dump and how can I find 
out what is oid 227715?

The problem database (oropdata) contains about 12 MB, the other two databases 
which are bigger (2 and 3 GB) seem to get dumped fine.

TIA
Nisai