Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group