Christian Platzer <christian@rainbow-solutions.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