Re: Restart after poweroutage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aklaver(at)comcast(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restart after poweroutage
Date: 2006-09-26 02:15:14
Message-ID: 18300.1159236914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <aklaver(at)comcast(dot)net> writes:
> On Monday 25 September 2006 02:48 pm, Tom Lane wrote:
>> I spent quite some time today trying to duplicate this failure (by
>> pulling the plug on an up-to-date Fedora Core 5 machine). No luck.

> Is there something I could do to help capture useful information
> should I see a repeat of this behavior?

What I'd really like to have is an strace of the postmaster when it
produces this error. If you're lucky, the failure will be repeatable
(ie, try to start the postmaster again and it fails again with same
error) and you can just strace it at that point. If it isn't repeatable
in that sense, that in itself is useful information, but capturing an
strace will be painful :-(

Also, if it is repeatable, "ipcs -m" output will be useful context.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-09-26 02:19:50 Re: Restart after poweroutage
Previous Message Adrian Klaver 2006-09-26 02:09:24 Re: Restart after poweroutage