pg_dump and pg_dumpall fail when trying to backup database - Mailing list pgsql-general

From jack_turer@yahoo.com (jack turer)
Subject pg_dump and pg_dumpall fail when trying to backup database
Date
Msg-id 8a58c331.0402171917.59634b14@posting.google.com
Whole thread Raw
Responses Re: pg_dump and pg_dumpall fail when trying to backup database
List pgsql-general
I have a database in pgsql (7.3.2) on redhat 9.

When I try a 'pg_dump mydb' to back up the database, I get:
pg_dump: could not find namespace with OID 2200

Verbose version is:
-bash-2.05b$ pg_dump -v mydb | more
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
pg_dump: could not find namespace with OID 2200
pg_dump: *** aborted because of error


Otherwise the database works just fine for daily use..etc,
just it cannot be backed up.

Anyone have any idea what is happening, or how to fix it?

Thank you!
Jack

pgsql-general by date:

Previous
From: "Simon Windsor"
Date:
Subject: Replication options
Next
From: Bill Moran
Date:
Subject: Problems with plpgsql and FOR loops