Re: [GENERAL] Terminating a rogue connection

2012-07-27 Thread Mark Morgan Lloyd
Chris Angelico wrote: On Fri, Jul 27, 2012 at 7:09 PM, Mark Morgan Lloyd wrote: Chris Angelico wrote: On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd wrote: Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inapp

Re: [GENERAL] Terminating a rogue connection

2012-07-27 Thread Chris Angelico
On Fri, Jul 27, 2012 at 7:09 PM, Mark Morgan Lloyd wrote: > Chris Angelico wrote: >> >> On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd >> wrote: >>> >>> Assuming a *nix server: if a monitoring program determines that an >>> established connection appears to be trying to so something >>> inapp

Re: [GENERAL] Terminating a rogue connection

2012-07-27 Thread Mark Morgan Lloyd
Chris Angelico wrote: On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd wrote: Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inappropriate, what's the best way of terminating that session rapidly? select pg_term

Re: [GENERAL] Terminating a rogue connection

2012-07-27 Thread Bèrto ëd Sèra
Hi all, in elderly versions, where pg_terminate_backend is missing, you'd issue a kill -15 from the command line. Bèrto On 27 July 2012 09:33, Chris Angelico wrote: > On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd > wrote: >> Assuming a *nix server: if a monitoring program determines that

Re: [GENERAL] Terminating a rogue connection

2012-07-27 Thread Chris Angelico
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd wrote: > Assuming a *nix server: if a monitoring program determines that an > established connection appears to be trying to so something inappropriate, > what's the best way of terminating that session rapidly? select pg_terminate_backend(procpi