pg_dump: schema with OID xxxxxxxx does not exist - Mailing list pgsql-admin

From Peter Neish
Subject pg_dump: schema with OID xxxxxxxx does not exist
Date
Msg-id 45418477.2020400@austehc.unimelb.edu.au
Whole thread Raw
Responses Re: pg_dump: schema with OID xxxxxxxx does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Running pg_dump gives this error:
pg_dump: schema with OID 37647910 does not exist

I've found a variation of this on the mailing list, but I'm not entirely
sure what to do about it.

I found this OID by running: select * from pg_type where typnamespace =
37647910;

and two entries:

        typname        | typnamespace | typowner | typlen | typbyval |
typtype | typisdefined | typdelim | typrelid | typelem | typinput  |
typoutput  | typreceive  |   typsend   | typalign | typstorage |
typnotnull | typbasetype | typtypmod | typndims | typdefaultbin | typdefault

-----------------------+--------------+----------+--------+----------+---------+--------------+----------+----------+---------+-----------+------------+-------------+-------------+----------+------------+------------+-------------+-----------+----------+---------------+------------
 entity_browse_bid_seq |     37647910 |     1005 |      4 | t        |
c       | t            | ,        | 37894096 |       0 | record_in |
record_out | record_recv | record_send | i        | p          |
f          |           0 |        -1 |        0 |               |
 entity_browse         |     37647910 |     1005 |      4 | t        |
c       | t            | ,        | 37894098 |       0 | record_in |
record_out | record_recv | record_send | i        | p          |
f          |           0 |        -1 |        0 |               |
(2 rows)

Does this mean that I can just delete these rows from this table for the
dump to work? Will deleting these rows affect anything else? Can you
tell that I'm not really sure what I am doing - I just need to get a
database from one server to another.

Thanks for any help you could give me,

Peter

pgsql-admin by date:

Previous
From: "Joshua Marsh"
Date:
Subject: Re: CLUSTER using more memory than expected
Next
From: "Simon Kinsella"
Date:
Subject: Re: Postgres timestamps are out by one hour