Find the users pointing to my database postgresql

Question

I logged into the psql console to delete some databases, but it gives me this error:

ERROR: database "production" is being accessed by other users DETAIL: There is 1 other session using the database.

How should I find the users pointing to my database?

Patrick · Accepted Answer · 2015-07-02 07:44:52Z

1

You can use the pg_stat_activity view. It will show pretty much everything that is of interest about every open session, such as the user (usename), where s/he is connecting from (client_addr and client_hostname), the state (active, idle, etc) and the last query (being) executed.

answered Jul 2, 2015 at 7:44

Patrick

33k7 gold badges73 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sqluser · Accepted Answer · 2015-07-02 07:47:54Z

0

You can get it from pg_user table

SELECT * FROM pg_user;

Or from pg_stat_activity view

SELECT usesysid, usename FROM pg_stat_activity;

answered Jul 2, 2015 at 7:47

sqluser

5,7027 gold badges44 silver badges52 bronze badges

Collectives™ on Stack Overflow

Find the users pointing to my database postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related