Nick Fankhauser wrote:
It most certainly does. You sure you don't have new connections coming
in all the time?
Pretty sure- That was my first thought as well, so I checked for stray
processes. I'm in the middle of something else right now, but this evening
I'll see if I can reproduce the problem and supply the details.
-Nick
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
What happens to me occasionally, is that I open pgAdminII and (in some versions and/or configurations) that opens all the DBs and delete-locks them. Other times I connect via psql (on a linux box) to the actual DB I'm trying to drop.
In other words, I found that often I'm the culprit myself. I now check regularly by executing:
$ ps auxwww | grep "^postgres" | grep -v grep | grep [database name]
and that shows me who is connected to the DB.
Andrew