Re: pg_dump after transaction id wraparound failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: "Michael L(dot) Boscia" <mikeboscia(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump after transaction id wraparound failure
Date: 2006-05-15 19:04:47
Message-ID: 11490.1147719887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Vacuum will make anything that disappeared by wraparound in the last
> billion transactions reappear, so a databasewide vacuum should solve
> all your problems, no need to dump...

Oh, I had forgotten about that. Did we establish that 7.4.* works that
way? I think so, but obviously I've been programming too many hours in
a row :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael L. Boscia 2006-05-15 19:07:05 Re: pg_dump after transaction id wraparound failure
Previous Message Tom Lane 2006-05-15 19:03:07 Re: pg_dump after transaction id wraparound failure