Little, Douglas wrote:
The only admin function that look close is
pg_terminate_backend(pid int) boolean Terminate a backend
I tried it and it couldn't be found. It is newist. We're running
PG8.2.13/GP3.3.7
Yes, that's an 8.4 function.
We tried pgpool for awhile, but I think I'll hav
Thanks
The only admin function that look close is
pg_terminate_backend(pid int) boolean Terminate a backend
I tried it and it couldn't be found. It is newist. We're running
PG8.2.13/GP3.3.7
>Oh, these connections aren't waiting for *database* events? Then
>you should either restructure
"Little, Douglas" wrote:
> Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] wrote:
>> "Little, Douglas" wrote:
>>
>>> We have a number of long running java/jdbc applications that
>>> wait for events and then extract data from PG.
>>> During the time the apps are running, The app is maintai
Sent: Friday, October 01, 2010 9:01 AM
To: Little, Douglas; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] how to PG close session
"Little, Douglas" wrote:
> We have a number of long running java/jdbc applications that wait
> for events and then extract data from PG.
> During
"Little, Douglas" wrote:
> We have a number of long running java/jdbc applications that wait
> for events and then extract data from PG.
> During the time the apps are running, The app is maintaining
> active connections to PG.
> Is there a way that we can close/terminate the pg session so tha
Hi,
We have a number of long running java/jdbc applications that wait for events
and then extract data from PG.
During the time the apps are running, The app is maintaining active
connections to PG.
Is there a way that we can close/terminate the pg session so that the
connections don't consum
