Corrupted DB. Help.

From: Anto Prijosoesilo <antop64(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Corrupted DB. Help.
Date: 2001-12-12 07:38:45
Message-ID: 20011212073845.67992.qmail@web13907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

One of my databases was running on PostgreSQL 6.5.1
and I accidentally corrupted the pg_class file. After
I restored the file from a backup, postgres would come
up but I can't see my tables. Only the system tables
are visible and trying to SELECT * FROM mytable
returned 0 rows.

SELECT * FROM pg_class only shows the system tables,
but VACUUM would go through all the tables.

pg_class' entry in pg_class table shows that it has 95
tuples but only 47 of them are listed when I do SELECT
* FROM pg_class.

Can someone help me recover my tables?

Thanks.

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Richard NAGY 2001-12-12 08:59:35 Big problem about libpq.so.2.1, ldconfig and ldd
Previous Message Heather Johnson 2001-12-11 17:22:19 Re: problems doing sub-selects on PostgreSQL 7.1.3 and Solaris 7