Postgres Pro
Downloads
Home   >   mailing lists

pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist' - Mailing list pgsql-general

From David Brain
Subject pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
Date
Msg-id BB8AF37F-E3D9-4DE0-B398-AF89748704F5@bandwidth.com
Whole thread Raw
Responses Re: pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@bandwidth.com
919.297.1078

pgsql-general by date:

Previous
From: "Philippe Lang"
Date:
Subject: ERROR: must be superuser to alter superusers
Next
From: "Scott Marlowe"
Date:
Subject: Re: ERROR: must be superuser to alter superusers