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!!
Regards.
