Re: pg_dump: schema with OID 1 does not exist

Christian Platzer <christian(at)rainbow-solutions(dot)net> writes:
> When we try to backup the database, pg_dump exits with the following error:
> pg_dump: schema with OID 1 does not exist

Say again about your software version? There is no such message in 7.3
pg_dump.

But anyway, I'd suggest looking through the system catalogs for objects
with 1 in their xxxnamespace field (pg_class.relnamespace,
pg_type.typnamespace, etc). What you ultimately want to do, I suspect,
is manually update the namespace field for any such object. But first
it would be interesting to understand how it got into this state.

regards, tom lane