Re: Help me recovering data - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Help me recovering data
Date
Msg-id 20050216085819.W49236@megazone.bigpanda.com
Whole thread Raw
In response to Re: Help me recovering data  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Help me recovering data  (pgsql@mohawksoft.com)
Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 16 Feb 2005, Joshua D. Drake wrote:

>
> >Do you have a useful suggestion about how to fix it?  "Stop working" is
> >handwaving and merely basically saying, "one of you people should do
> >something about this" is not a solution to the problem, it's not even an
> >approach towards a solution to the problem.
> >
> >
> I believe that the ability for PostgreSQL to stop accepting
> queries and to log to the file or STDERR why it stopped working
> and how to resolve it is appropriate.

Right, but since the how to resolve it currently involves executing a
query, simply stopping dead won't allow you to resolve it. Also, if we
stop at the exact wraparound point, can we run into problems actually
trying to do the vacuum if that's still the resolution technique?  If so,
how far in advance of wraparound must we stop to guarantee it will
succeed? It's not rocket science, but figuring such things out is part of
actually making a workable solution.




pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Help me recovering data
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: Help me recovering data