zope, postgresql and idle connections

From: stefan_felkel(at)yahoo(dot)com (Stefan Felkel)
To: pgsql-general(at)postgresql(dot)org
Subject: zope, postgresql and idle connections
Date: 2004-06-03 08:25:20
Message-ID: cabd5fc8.0406030025.3093f1f3@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Bambero 2004-06-03 10:11:40 row access
Previous Message Lee Fesperman 2004-06-03 08:06:55 Re: JDBC: what exactly does nullsAreSortedHigh() return?