pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_dump: schema with OID 1 does not exist
2+ messages / 2 participants
[nested] [flat]

* pg_dump: schema with OID 1 does not exist
@ 2004-08-05 06:07  Christian Platzer <christian@rainbow-solutions.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Christian Platzer @ 2004-08-05 06:07 UTC (permalink / raw)
  To: pgsql-admin

-----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-----



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_dump: schema with OID 1 does not exist
@ 2004-08-05 14:03  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Christian Platzer <christian@rainbow-solutions.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-08-05 14:03 UTC (permalink / raw)
  To: Christian Platzer <christian@rainbow-solutions.net>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-08-05 14:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-05 06:07 pg_dump: schema with OID 1 does not exist Christian Platzer <christian@rainbow-solutions.net>
2004-08-05 14:03 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox