| From: | Sathish Duraiswamy <sathish(at)leatherlink(dot)net> |
|---|---|
| To: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
| Cc: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br>, GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: idle users |
| Date: | 2009-03-05 19:39:27 |
| Message-ID: | fa94608e0903051139y714bb289l6758acffb937c618@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Can we automate this process , maintained by postmaster itself
Regards
Sathish
On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley <eggyknap(at)gmail(dot)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(at)leatherlink(dot)net
Website : http://www.leatherlink.net
Contact : +91 44 65191757
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-03-05 19:51:42 | Re: idle users |
| Previous Message | Sathish Duraiswamy | 2009-03-05 19:35:15 | Re: converting older databases |