Re: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Brain <dbrain(at)bandwidth(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
Date: 2007-09-24 14:58:54
Message-ID: 13986.1190645934@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Brain <dbrain(at)bandwidth(dot)com> writes:
> I am getting the error mentioned in the subject ('pg_dump: schema
> with OID 1515546 does not exist') when I try to back up one database
> out of a cluster of half a dozen or so on our server.

Well, for starters, troll through the system catalogs in that database
to see which object(s) reference that schema OID, eg,
select * from pg_class where relnamespace = 1515546;
and similarly for other catalogs that have a namespace column. Once you
know where the problem is it'll be easier to figure out what happened
and what to do about it.

What PG version is this?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-24 15:06:31 Re: DELETE FROM pg_class
Previous Message Alvaro Herrera 2007-09-24 14:00:25 Re: SRF called with optional NULL input runs 7x slower