Re: hung postmaster? - Mailing list pgsql-general

From Ed L.
Subject Re: hung postmaster?
Date
Msg-id 200502161141.35328.pgsql@bluepolka.net
Whole thread Raw
In response to Re: hung postmaster?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: hung postmaster?
List pgsql-general
On Wednesday February 16 2005 8:54, Tom Lane wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > Postmaster is totally
> > unresponsive to SIGTERM, SIGINT, and SIGQUIT  (sigkill is
> > the only thing that shuts it down).
>
> gdb backtrace definitely sounds like a good idea.  Also it
> might be interesting to see the results of strace of the
> postmaster while hitting it with signals.  Find out if it's
> doing anything at all in response ...

Workin' on gdb/strace build, but having trouble with both.  Gdb
just doesn't build from source, not sure why yet, and no depots
found at porting center.  It doesn't appear that strace is
supported for 11.23 itanium based on strace README/PORTING files
and 'man 2 ptrace'.  HPUX users, is that your experience?

Question:  Am I doing all I can to avoid corruption with the
following procedure to shutdown a 7.4.6 cluster with a hung
postmaster?  Suggestions?

1.  SIGTERM non-postmaster processes
2.  SIGINT non-postmasters
3.  SIGQUIT non-postmaster
4.  SIGTERM postmaster
5.  SIGINT postmaster
6.  SIGQUIT postmaster
7.  SIGKILL postmaster

TIA.

Ed


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL vs. MySQL vs. Oracle, 2005 report card
Next
From: Bruno Wolff III
Date:
Subject: Re: Question regarding threaded mode