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

From: David Brain <dbrain(at)bandwidth(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
Date: 2007-09-24 12:21:25
Message-ID: BB8AF37F-E3D9-4DE0-B398-AF89748704F5@bandwidth.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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. This is a
production DB and the database in question _seems_ to be working OK,
other than the issue with pg_dump, however the fact that I am seeing
this does make be somewhat concerned. I suspect it was caused when
an autovacuum process was killed (due to memory issues exhaustion).

Any advice as to what can be done to track down and resolve this
problem, dropping and restoring the DB isn't _completely_ out of the
question, but I'd like to avoid it if at all possible.

Thanks,

David.

David Brain
dbrain(at)bandwidth(dot)com
919.297.1078

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-09-24 12:40:05 Re: ERROR: must be superuser to alter superusers
Previous Message Philippe Lang 2007-09-24 12:20:52 ERROR: must be superuser to alter superusers