| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: how to PG close session |
| Date: | 2010-10-01 19:03:36 |
| Message-ID: | 4CA63088.8040808@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)2ndQuadrant(dot)com 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Fehrle | 2010-10-01 19:28:54 | creating language plperl fails in windows 7 |
| Previous Message | Tena Sakai | 2010-10-01 17:46:11 | Re: I can't get postgres started. |