Hi Mark, <br><br>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. <br>Now It is ok..<br>Thank you again. <br><br>Baris<br><br><b><i>Mark Cave-Ayland <m.cave-ayland@webbased.co.uk></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 11 (filtered medium)"> <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"> <o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="address"> <o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"> <!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:blue; text-decoration:underline;} p {mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; font-size:12.0pt; font-family:"Times New Roman";} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page
Section1 {size:612.0pt 792.0pt; margin:72.0pt 90.0pt 72.0pt 90.0pt;} div.Section1 {page:Section1;} --> </style> </o:SmartTagType></o:SmartTagType></o:SmartTagType></o:SmartTagType></o:SmartTagType><div class="Section1"> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Hi Baris,<o:p></o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">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.<o:p></o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Kind regards,<o:p></o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Mark.<o:p></o:p></span></font></div> <div> <div><font color="navy" face="Times New Roman" size="2"><span style="font-size: 10pt;
color: navy;">------------------------<br> WebBased Ltd<br> <st1:Street w:st="on"><st1:address w:st="on">17 Research Way</st1:address></st1:Street><br> <st1:place w:st="on"><st1:City w:st="on">Plymouth</st1:City></st1:place><br> PL6 8BT<br> <br> T: +44 (0)1752 797131<br> F: +44 (0)1752 791023<br> <br> <a href="http://www.webbased.co.uk">http://www.webbased.co.uk</a> <br> <a href="http://www.infomapper.com">http://www.infomapper.com</a><br> <a href="http://www.swtc.co.uk">http://www.swtc.co.uk</a> <br> <br> 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.</span></font><o:p></o:p></div> </div> <div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color
-moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0cm 0cm 0cm 4pt;"> <div> <div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> <hr tabindex="-1" align="center" size="2" width="100%"> </span></font></div> <div class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <b><span style="font-weight: bold;">On Behalf Of </span></b>Baris YILMAZ<br> <b><span style="font-weight: bold;">Sent:</span></b> 01 June 2006 23:01<br> <b><span style="font-weight: bold;">To:</span></b> <st1:PersonName w:st="on">PostGIS Users Discussion</st1:PersonName><br> <b><span style="font-weight: bold;">Subject:</span></b>
[postgis-users] How to terminate postgres.exe processesautomatically after queries</span></font><o:p></o:p></div> </div> <div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><o:p> </o:p></span></font></div> <div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi all,<br> <br> I have a problem. I have a Java application which executes many spatial queries with postgresql database with JDBC. <br> <br> 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.<br> <br> Can anyone tell me how to end these processes automatically, after my postgresql connection has been terminated?<br> <br> Thank you<br> <br> Baris<o:p></o:p></span></font></div> <div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;"> <hr align="center" size="1" width="100%"> </span></font></div> <div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Do you Yahoo!?<br> Everyone is raving about the <a href="http://us.rd.yahoo.com/evt=40791/*http:/advision.webevents.yahoo.com/handraisers">all-new Yahoo! Mail Beta.</a><o:p></o:p></span></font></div> </div> </div> _______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote><br><p> __________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com