Re: production server down

On Wed, Dec 15, 2004 at 11:41:02AM -0800, Joe Conway wrote:

> Just wanted to close the loop for the sake of the list archives. With 
> Tom's xlog dump tool I was able (with a bunch of his help off-list) to 
> identify the needed parameters for pg_resetxlog. Running pg_resetxlog 
> got us back a running database. We're now involved in checking the data.

Any chance you could write up a summary of the thread: what caused
the problem, how you diagnosed it, how you fixed it, and how to
avoid it?  Might make a useful "lessons learned" document.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/