| From: | Ralf Tschiersch <ralf(at)net-service(dot)de> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Structure damaged? Need help |
| Date: | 2000-10-01 15:14:31 |
| Message-ID: | Pine.LNX.4.10.10010011710050.938-100000@dilbert.net-service.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
after a crash and brainlessly having deleted pg_log, the structure of the
db seems to be damaged. There are no databases and tables to be found, but
a certain "select" shows up a query-result with no tuples returned.
Inside the data/base/*-Directory all data seems to be there and up to
date, which means: There are files named by tables and filled with lots of
well-known data.
How can I get back the data? Recovering the structure is no problem, but
the current content must be transferred! I hope I described the problem so
than someone gets the idea an can help!
PG is 5.4.3 on Linux 2.2.10
Thanks for you help
Ralf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-10-01 17:54:08 | Re: pg_log deleted - what to do? |
| Previous Message | Hassanuri Bin Shah | 2000-10-01 13:56:04 | i am a fool |