Postgres Pro
Downloads
Home   >   mailing lists

Re: idle users - Mailing list pgsql-general

From Sathish Duraiswamy
Subject Re: idle users
Date
Msg-id fa94608e0903051139y714bb289l6758acffb937c618@mail.gmail.com
Whole thread Raw
In response to Re: idle users  (Joshua Tolley <eggyknap@gmail.com>)
Responses Re: idle users  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view
Can we automate this process , maintained by postmaster itself

Regards
Sathish

On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley <eggyknap@gmail.com> wrote:
On Thu, Mar 05, 2009 at 04:50:09AM -0800, paulo matadr wrote:
>    I need to procedure to kill users in idle,anybody have this made?
>    thanks

See pg_cancel_backend.
http://www.postgresql.org/docs/8.3/static/functions-admin.html

- Josh / eggyknap

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkmv/nQACgkQRiRfCGf1UMP0uQCcCZXH4XivHZqfAWUngpPaIDct
fVUAoJkna4zTGgDzyuv4ay5UdK114Czk
=Kk08
-----END PGP SIGNATURE-----




--
BSG LeatherLink Pvt Limited,
Mail To : sathish@leatherlink.net
Website : http://www.leatherlink.net
Contact : +91 44 65191757

pgsql-general by date:

Previous
From: Sathish Duraiswamy
Date:
Subject: Re: converting older databases
Next
From: darren@ontrenet.com
Date:
Subject: Re: not quite a cross tab query...