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 Mendola||Date: 2004-01-30 00:25:40|
|Subject: commit after dead lock|
|Previous:||From: Sam Barnett-Cormack||Date: 2004-01-29 23:36:37|
|Subject: Re: Help: System requirements for postgresql 7.4.1|