Re: Forcing connections closed

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Juan Miguel <juanmime(at)ono(dot)com>
Cc: Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>, "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>, PGSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Forcing connections closed
Date: 2004-01-29 23:52:31
Message-ID: Pine.LNX.4.33.0401291649130.30883-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-01-30 00:25:40 commit after dead lock
Previous Message Sam Barnett-Cormack 2004-01-29 23:36:37 Re: Help: System requirements for postgresql 7.4.1