From: Anto Prijosoesilo <antop64@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Corrupted DB. Help.
Date: Tue, 11 Dec 2001 23:38:45 -0800 (PST)
Message-ID: <20011212073845.67992.qmail@web13907.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: antop64@yahoo.com
Subject: Re: Corrupted DB. Help.
In-Reply-To: <20011212073845.67992.qmail@web13907.mail.yahoo.com>
References: <20011212073845.67992.qmail@web13907.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox