Help pg_dump: failed sanity check

From: "Dr(dot) Nisai Wanakule" <nisai(at)m1p17-235(dot)waterauthority(dot)state(dot)fl(dot)us>
To: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Help pg_dump: failed sanity check
Date: 1999-08-30 20:34:02
Message-ID: 199908302034.QAA05892@m1p17-235.waterauthority.state.fl.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In an attemp to move to 6.5.1 I did pg_dumpall an get the following message:

postgres(at)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

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Field 1999-08-30 21:02:18 Installation Prob
Previous Message The Hermit Hacker 1999-08-30 19:20:34 Test, ignore ...