Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump: schema with OID 1 does not exist

pg_dump: schema with OID 1 does not exist

From
Christian Platzer
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there.
We have a big problem with one of our databases.
Postgres Server 7.3

When we try to backup the database, pg_dump exits with the following error:
pg_dump: schema with OID 1 does not exist
The same issue appears when we copy the entire database and try it again.

All the data are stored in the public schema.

Thanks a lot for helping me!

Christian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBEc66BaT26XNCfvQRAn2uAJ4gN+tFuNaxllRmEKls3Bm0/jg8qQCfasTg
Fu1QcPD4CvTj0ZAXmHR+NyU=
=FtuX
-----END PGP SIGNATURE-----

Re: pg_dump: schema with OID 1 does not exist

From
Tom Lane
Date:
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