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 have a look at the code first.
I did find in the JDBC doc connections.close which should do the trick I suspect.
Does your Java app have an application server like Tomcat in it? Those
can be setup to work about as well as a PostgreSQL specific pooler, and
you get tighter integration with the application itself normally in the
process.
--
Greg Smith, 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
