Re: production server down

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: production server down
Date: 2004-12-15 21:16:48
Message-ID: 20041215211648.GA27182@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2004-12-15 21:27:44 Re: V8.0rc1 On AIX.
Previous Message Andrew Dunstan 2004-12-15 21:05:36 race condition for drop schema cascade?