pg_dump: schema with OID xxxxxxxx does not exist

Поиск
Список
Период
Сортировка
От Peter Neish
Тема pg_dump: schema with OID xxxxxxxx does not exist
Дата
Msg-id 45418477.2020400@austehc.unimelb.edu.au
обсуждение исходный текст
Ответы Re: pg_dump: schema with OID xxxxxxxx does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua Marsh"
Дата:
Сообщение: Re: CLUSTER using more memory than expected
Следующее
От: "Simon Kinsella"
Дата:
Сообщение: Re: Postgres timestamps are out by one hour