zope, postgresql and idle connections
От | stefan_felkel@yahoo.com (Stefan Felkel) |
---|---|
Тема | zope, postgresql and idle connections |
Дата | |
Msg-id | cabd5fc8.0406030025.3093f1f3@posting.google.com обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: