EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

While executing pg_dump getting error  XML

Forum Index » Postgres Plus Advanced Server
Author Message
sanjeev_k

Member

Joined: 4 Oct 2006 01:56:16
Messages: 47
Offline

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
Anonymous



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
shoaib2

Senior member

Joined: 25 Mar 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...
Anonymous



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
 
Forum Index » Postgres Plus Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team