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

[Baris YILMAZ]

Hi Mark, 

Thank you very much for your reply. I solved the matter. I closed the database connection with close() function in JDBC. Previously, It was not executed. 
Now It is ok..
Thank you again. 

Baris

Mark Cave-Ayland <m.cave-ayland at webbased.co.uk> wrote:        v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}         st1\:*{behavior:url(#default#ieooui) }           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 Yahoo! Mail Beta.
  
  
  _______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060602/1bf93e4f/attachment.html>