473,320 Members | 2,073 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

zope, postgresql and idle connections

hi!

i have searched a lot in these pgsql-groups and on the internet, but
found no really helpful information for my problem.

the famous error
database "xyz" is being accessed by other users


is my problem.

i use postgesql 7.3.2 and zope 2.6.1 (python 2.1.3).
i want to create and drop databases. creating is no problem and my
script works fine. but dropping is the problem - postgres don't wanna
drop the db (bin/dropdb). i haven't found an option that ignores these
error-messages and drops the db anyway. nor i have found any command
which allows me to manage connections.

i see the only solution in killing the connections via cmd "kill" and
searching for connections via "ps" before.

steffel 430 0.0 0.1 41572 292 std- S Wed08AM 0:00.01
postgres: stats buffer process
steffel 431 0.0 0.1 40584 308 std- S Wed08AM 0:00.09
postgres: stats collector process
steffel 678 0.0 0.1 41096 508 ?? S Wed09AM 0:00.33
postgres: steffel blogger [local] idle
steffel 682 0.0 0.1 41096 508 ?? S Wed09AM 0:00.34
postgres: steffel blogger [local] idle
steffel 758 0.0 0.1 40840 500 ?? S 10:40AM 0:00.05
postgres: steffel iug1 [local] idle
steffel 766 0.0 0.1 40840 500 ?? S 10:56AM 0:00.01
postgres: steffel iug1 [local] idle
steffel 767 0.0 0.1 41096 568 ?? S 10:56AM 0:00.04
postgres: steffel blogger [local] idle
steffel 768 0.0 0.1 40840 500 ?? S 10:56AM 0:00.02
postgres: steffel xyz [local] idle
steffel 770 0.0 0.1 40840 500 ?? S 11:00AM 0:00.03
postgres: steffel iug1 [local] idle
steffel 771 0.0 0.1 41096 568 ?? S 11:00AM 0:00.06
postgres: steffel blogger [local] idle
steffel 772 0.0 0.1 40840 500 ?? S 11:00AM 0:00.02
postgres: steffel xyz [local] idle
steffel 1006 0.0 0.2 41096 832 ?? S 1:25PM 0:00.04
postgres: steffel blogger [local] idle

is there any suggestions from you? or does anybody know how to close a
connection with zope (just "close connection" in the control panel
didn't help).
i would be

thanks a lot!
stefan felkel
Nov 23 '05 #1
0 1422

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Philippe Lang | last post by:
Hello, After using Postgresql for a while, through ODBC / MS Access, I'm not able to connect to the server anymore. The server reports "Too many clients connected already". With a "ps -afx",...
26
by: Jon Pastore | last post by:
I have a strange error. when I do a ps aux I get: postgres 15018 0.0 0.6 9192 7396 ? S 09:20 0:00 /usr/bin/perl /www/nexum/cgi-bin/accounting/posting/automatic_posting postgres...
4
by: Josh Close | last post by:
Is there a way to remove idle connections? My postgres server is getting serveral hundred idle connections. It's due to a postgres .NET provider not closing the connections properly. I don't want...
1
by: Praveen_db2 | last post by:
Hi All I came across a small doubt. Suppose I have Max Connections parameter set to 200. There are now 200 connections to the database. Out of these 200 connections 50 are idle. What will happen...
4
by: Troels Arvin | last post by:
Hello, Some of our SAS users seem to initiate 20+ idle connections to DB2 every time they start SAS. I'm inclined to tell them to cut down on their DB2 connection number, but then again, if the...
2
by: dantz | last post by:
Having a multiple client/server using a C# httplistener/httpwebrequest to transfer message. How should I handle idle connections? Will it be the job of the server or client? Does using a ping...
2
by: Nebu Pulickal | last post by:
I am having a postgresql database server and the idle connections are not closing themselves. They are increasing to large numbers as time passes and the web page is not loading. The code developer...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.