Re: How does PG know when a database is being accessed ?

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