While executing pg_dump getting error

From http://forums.enterprisedb.com/posts/list/1070.page

Anonymous



Hi Sir,

I connected to SSH(secure shell) and taking dump as follows:
------------------------
[root@localhost dbserver]# bin/pg_dump "dbname" -h <> -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


29/08/2007 04:13:37 Subject: Re:While executing pg_dump getting error
shoaib2

Senior member

Joined: 25/03/2008 02:56:43
Messages: 333
Offline
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...