Corrupt catalog

Started by Nykolyn, Andrewover 20 years ago1 messageshackers
Jump to latest
#1Nykolyn, Andrew
andrew.nykolyn@ngc.com

In trying to determine why I had a corrupted piece of data (still
investigating that) I created a temporary table that contained the row
of data in question. In doing so, I must have done something to the
pg_catalog because I no longer was able to perform a dump without
getting the following error:

pg_dump: schema with OID 469554554 does not exist

I recycled the server. I cannot see the temporary table anywhere as
(expected) through psql or PG Admin. However, looking at the pg catalog
I found the above OID referenced in the tables in the attached
spreadsheet with the name of the temporary table that I created. My
database is functioning without problem. However, I cannot perform a
database dump. Please advise on how I can correct this problem. I am
working in a PosgteSQL 7.4.2 database on a Red Hat Linux 8.0 OS.

With Great Thanks,

Andy Nykolyn
Northrop Grumman
<<catalog_data.xls>>

Attachments:

catalog_data.xlsapplication/vnd.ms-excel; name=catalog_data.xlsDownload