pg_dump and pg_dumpall fail when trying to backup database

From: jack_turer(at)yahoo(dot)com (jack turer)
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump and pg_dumpall fail when trying to backup database
Date: 2004-02-18 03:17:47
Message-ID: 8a58c331.0402171917.59634b14@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-02-18 03:43:06 Re: String manipulation
Previous Message Greg Sabino Mullane 2004-02-18 01:40:00 Re: Check for prepared statement