Re: Forcing connections closed - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Forcing connections closed
Date
Msg-id Pine.LNX.4.33.0401291649130.30883-100000@css120.ihs.com
Whole thread Raw
In response to Re: Forcing connections closed  (Juan Miguel <juanmime@ono.com>)
Responses Re: Forcing connections closed  (Juan Miguel <juanmime@ono.com>)
List pgsql-admin
On Thu, 29 Jan 2004, Juan Miguel wrote:

> You can kill the procs (connections) using kill -9 PID

Just use kill PID first!

'kill -9' PID will force all backends to flush cache for no good reason.

Note that on most unixes, a plain kill PID will send the term signal,
which tells the process to poltely shutdown and release resources.  kill
-9 is like using a sledge hammer to swat a fly for this.


pgsql-admin by date:

Previous
From: Sam Barnett-Cormack
Date:
Subject: Re: Help: System requirements for postgresql 7.4.1
Next
From: Gaetano Mendola
Date:
Subject: commit after dead lock