Re: Missing tables in postgresql 7.2.4 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Missing tables in postgresql 7.2.4
Date
Msg-id 543.1115908885@sss.pgh.pa.us
Whole thread Raw
In response to Re: Missing tables in postgresql 7.2.4  ("Michael Beckstette" <mbeckste@TechFak.Uni-Bielefeld.DE>)
List pgsql-bugs
"Michael Beckstette" <mbeckste@TechFak.Uni-Bielefeld.DE> writes:
> two last questions about the transaction ID wraparound problem of my DBs I had
> yesterday (see former postings). After applying the 'recovery procedure' Tom
> suggested now my XIDs are looking almost fine again, except for the template0
> DB.

You don't have to worry about template0 -- it was "frozen" during initdb
and does not need vacuuming.

> My second point is more a suggestion. After Toms strategy worked quite
> well (at least for me) it is maybe worthwhile to put it somewhere in
> the docs. Maybe together with other things in a section called
> 'Disaster recovery strategies'?

I'm not sure it can be claimed to be tested well enough to publish as a
recovery strategy.  I'm glad it worked for you, but ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Sankaran Anupama"
Date:
Subject: Re: Do dropdb and createdb read password from .pgpass
Next
From: Tom Lane
Date:
Subject: Re: BUG #1578: ::bit(n) behaves "differently" if applied to bit