While executing pg_dump getting error

Hi,

[root@localhost dbserver]# bin/pg_dump "dbname" -h <<hostip>> -p 5432 -U "enterprisedb" -F c -
v -f "/usr/local/dbname.tar" -i
Password:
pg_dump: reading schemas
pg_dump: reading user-defined packages
pg_dump: reading user-defined synonyms
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: schema with OID 58220 does not exist
pg_dump: *** aborted because of error

Thanks in advance,
-Sanjeev

Hi Sir,

I connected to SSH(secure shell) and taking dump as follows:
------------------------
[root@localhost dbserver]# bin/pg_dump "dbname" -h <<hostip>> -p 5432 -U "enterprisedb" -F c -
v -f "/usr/local/dbname.tar" -i
Password:
pg_dump: reading schemas
pg_dump: reading user-defined packages
pg_dump: reading user-defined synonyms
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: schema with OID 58220 does not exist
pg_dump: *** aborted because of error
--------------------------------

But I am getting the above schema with OID 58220 error
What should I do.
Please Help me out from this error.
Thanks in advance,
-Sanjeev

That looks like a corrupted database to me.

Can you show us the output for:

select oid,nspname from pg_namespace where oid=58220;

If you don't see it there and I assume it wont be there, now try looking for this OID through out the system catalogs.

Using something like:

select * from pg_type where typnamespace=58220;

And use the same for following catalog tables:

pg_class
pg_operator
pg_conversion
pg_opclass
pg_aggregate
pg_proc

and search for the specific oid in the following columns:

pg_class.relnamespace
pg_operator.oprnamespace
pg_conversion.connamespace
pg_opclass.opcnamespace
pg_aggregate.aggnamespace
pg_proc.pronamespace

Let us know the output of all...

Thanks Shoaib,

You are right, it's missed in one of the catalog tables.

I deleted that row and I tested pg_dump it's worked fine.

But I've one quesion ?
Is there any side effects by deleting the row.

Pls advise me.

Thanks,
-Sanjeev