pg_dump(all) fails with "failed sanity chec, type with oid ..."

From: Mark R DeLong <mdelong(at)cgt(dot)mc(dot)duke(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump(all) fails with "failed sanity chec, type with oid ..."
Date: 2001-07-18 17:43:56
Message-ID: 3B55CADC.3D6D33B3@cgt.mc.duke.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

pg_dump/pg_dumpall fail with the following messages (verbose output
selected):

...
-- dumping out user-defined procedural languages
-- dumping out user-defined functions
failed sanity check, type with oid 59770787 was not found

OS: Linux kernel 2.2.16
PostgreSQL v. 7.0.3

I've seen similar posts and suggested resolutions to the problems (which
I haven't been able to use), and I think this is a bug that's been put
on a TODO list.

So, two questions:

1) Is a bugfix for pg_dump/pg_dumpall available, perhaps in the 7.1
version?
2) If the bugfix is available in 7.1, can I safely migrate data from
7.0.3 to 7.1, if i use the COPY command to export and import tables.

Thanx.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-07-18 17:52:45 OID wraparound (was Re: pg_depend)
Previous Message will trillich 2001-07-18 17:42:19 Re: psql -l