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
Little, Douglas douglas.lit...@orbitz.com 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
, 2010 9:01 AM
To: Little, Douglas; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] how to PG close session
Little, Douglas douglas.lit...@orbitz.com 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
Little, Douglas douglas.lit...@orbitz.com wrote:
Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] wrote:
Little, Douglas douglas.lit...@orbitz.com 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
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:
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