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
