I need to procedure to kill users in idle,anybody have this made?
thanks
Paulo Moraes
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
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
signature.asc
Description: Digital signature
Can we automate this process , maintained by postmaster itself
Regards
Sathish
On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley eggyk...@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?
On Fri, 2009-03-06 at 01:09 +0530, Sathish Duraiswamy wrote:
Can we automate this process , maintained by postmaster itself
No and that would be a bad idea. There has been discussion in the past
of having an IDLE in TRANSACTION timeout but that is a different thing.
Joshua D. Drake
--
Thanks for your reply.
Can we have script in cron jobs to do this step periodically
If possible , can anyone help for cron script to do this job .
Regards
sathish
On Fri, Mar 6, 2009 at 1:21 AM, Joshua D. Drake j...@commandprompt.comwrote:
On Fri, 2009-03-06 at 01:09 +0530, Sathish
On Thu, Mar 5, 2009 at 9:31 AM, Joshua Tolley eggyk...@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.
On Thu, Mar 5, 2009 at 5:50 AM, paulo matadr saddon...@yahoo.com.br wrote:
I need to procedure to kill users in idle,anybody have this made?
thanks
Paulo Moraes
Here's a really primitive bash script to kill off all idle
connections. Run it as postgres:
#!/bin/bash
for i in `psql -U postgres