| 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
| 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 |