Re: idle users

[Sathish Duraiswamy <sathish@xxxxxxxxxxxxxxx>]

Can we automate this process , maintained by postmaster itself

Regards
Sathish

On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley <eggyknap@xxxxxxxxx> 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@xxxxxxxxxxxxxxx
Website : http://www.leatherlink.net
Contact : +91 44 65191757