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
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? |