Joshua Berry <yoberi@xxxxxxxxx> writes:
> [jberry@dms dms]$ pg_dump -U dms_user -s dms > dms_s.sql
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:Â could not open relation
> with OID 27224
> pg_dump: The command was: SELECT
> pg_catalog.pg_get_viewdef('27289'::pg_catalog.oid) as viewdef
This looks like catalog corruption :-(. Can you find a pg_class row
with that OID, ie
select * from pg_class where oid = 27224
I expect probably not, but then try it with enable_indexscan and
enable_bitmapscan turned off. If that finds a row, then what you
have is a corrupt pg_class_oid_index and you can probably get out
of trouble by reindexing it. You should also look at what 27289
is so you know what view is causing the problem.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
