pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_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>
2004-08-05 14:03 ` Re: pg_dump: schema with OID 1 does not exist Tom Lane <tgl@sss.pgh.pa.us>
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 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>
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