Postgres Pro
Downloads
Home   >   mailing lists

How can I see which users are connected? - Mailing list pgsql-general

From Jacob Vennervald Madsen
Subject How can I see which users are connected?
Date
Msg-id EB0B5D39043C344BA53B0F4AB15AE633029943@gop-server.GOP-server.local
Whole thread Raw
List pgsql-general
Tree view 
Hi List

I'm trying to drop a database but I get this error:
ERROR:  DROP DATABASE: database "mydb" is being accessed by other users

How can I see which user that is and from where he is connected?

Jacob

pgsql-general by date:

Previous
From: joerg.naumann@miele.de
Date:
Subject: error can't select an agregate function
Next
From: Fernando Lozano
Date:
Subject: Re: FREE ERD TOOL for POSTGRES ???