"Ben Osborne" <bosborne@bsdmarketing.co.uk> writes:
> 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).
The symptoms seem reasonably consistent with the theory that you have
suffered transaction ID wraparound. How large is the $PGDATA/pg_log
file? If it's exactly 1Gb then this is almost certainly the answer.
> My Question is, is there ANY means by which I can get at the data.
I believe it is possible to reset the transaction counter to something a
little bit less than 4 billion, which will make everything up to that
point appear to be "in the past" again. I have long since forgotten the
details, but digging in the list archives should turn up some discussion
of how to do that in 7.0. Then do a quick pg_dumpall, initdb and
reload.
You should seriously consider updating to a more modern PG version
while you are at it ...
regards, tom lane