On Thu, Mar 5, 2009 at 5:50 AM, paulo matadr 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 -t -c "select procpi
On Thu, Mar 5, 2009 at 9:31 AM, Joshua Tolley 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
I j
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 wrote:
> On Fri, 2009-03-06 at 01:09 +0530, Sathish Duraiswamy wrote:
> > Can we a
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
--
Postgre
Can we automate this process , maintained by postmaster itself
Regards
Sathish
On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley 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_
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
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