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