Re: [ADMIN] Immediate Shutdowns - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: [ADMIN] Immediate Shutdowns
Date
Msg-id bde871fb-f410-d162-a0f9-104e3aae4dd2@2ndquadrant.com
Whole thread Raw
In response to [ADMIN] Immediate Shutdowns  (Harold Falkmeyer <hfalkmeyer@gmail.com>)
List pgsql-admin
On 6/6/17 22:56, Harold Falkmeyer wrote:
> Are there long-term detriments from executing an immediate shutdown
> and/or issuing SIGQUITs to either the parent or any child postmaster?

There shouldn't be any.

> What might cause an operation, such as a VACUUM ANALYZE, not to exit
> upon receiving a SIGTERM.  Are there any circumstances when a SIGQUIT
> could fail to cause an imminent exit (other than a process in an
> fundamentally unreceptive state, such as an uninterruptible sleep).

You write in another thread that you are using 8.4.  That could
certainly have more issues/bugs in this area, if you're not seeing the
behavior you want.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-admin by date:

Previous
From: Harold Falkmeyer
Date:
Subject: [ADMIN] Immediate Shutdowns
Next
From: x_hsky
Date:
Subject: [ADMIN] PG 10.0 Distributed Configuration