[postgis-users] How to terminate postgres.exe processesautomatically after queries

[Mark Cave-Ayland]

Hi Baris,

 

This is more a PostgreSQL question than a PostGIS question, but PostgreSQL
creates one process per connection to the database, so it sounds as if your
JDBC driver/app is either not closing used connections, or making use of
some kind of connection pooling mechanism which is configured for a large
pool size.

 

 

Kind regards,

 

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk  
http://www.infomapper.com
http://www.swtc.co.uk 

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Baris
YILMAZ
Sent: 01 June 2006 23:01
To: PostGIS Users Discussion
Subject: [postgis-users] How to terminate postgres.exe
processesautomatically after queries

 

Hi all,

I have a problem. I have a Java application which executes many spatial
queries with postgresql database with JDBC. 

After the queries are executed, if I open the task manager, I still see many
postgres.exe prozesses (may be 60) which are still working, each of them
approx. 3000 kB. I have to end them manually.

Can anyone tell me how to end these processes automatically, after my
postgresql connection has been terminated?

Thank you

Baris

  _____  

Do you Yahoo!?
Everyone is raving about the all-new
<http://us.rd.yahoo.com/evt=40791/*http:/advision.webevents.yahoo.com/handra
isers>  Yahoo! Mail Beta.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060602/9e53a03b/attachment.html>