Postgres 7.0.2 Problem
I am having a rather big problem with an installation of postgres 7.0.2 on
cobalt, in that the db server is unable to see any of the data stored in the
(only) database which is running (other than template1). I suspect that the
files in the data directory have been conrrupted or otherwise lost
integrity, possibly due to the fact that the disk partition where the db
cluster is running has reached 100% usage.
The problem is the -l doesn't list my database in the catalog, although i
can psql xxxxx into the database. Further, \d lists 'No Relations', however
i can select * from a table, and although the database reports no rows, the
table scheme does report correctly.
In terms of backup, all I have is a copy of the data directory itself.
Unfortunately I was stupid enough not to have ever used pg_dumpall.
My Question is, is there ANY means by which I can get at the data. I
understand that in later versions there is a pg_resetxlog tool which can
help with problems like this, but unfortunately not in 7.0.2. Does anybody
know if there is an equivalent tool available for my version of the
database? Alternatively, is there any other facility available which can
extract the data from the data files in a form that I could work with?
I have laready tried re initialising the db on a larger disk partion and
moving the data files around, but to no avail.
Any help would be very welcome!!
- Re: at 2004-10-19 15:41:53 from Andrew Sullivan
- Re: at 2004-10-19 16:30:16 from Tom Lane
pgsql-hackers by date
|Next:||From: D. Richard Hipp||Date: 2004-10-19 12:29:55|
|Subject: Re: embedded postgresql|
|Previous:||From: Christopher Kings-Lynne||Date: 2004-10-19 11:44:54|
|Subject: Re: Time off|