Tag: sessions

PostgreSQL Error: database is being accessed by other users

In this article, we will the solution for PostgreSQL Error: database is being accessed by other users
Detail: There are 2 other sessions using the database

ERROR database is being accessed by other users
Continue reading PostgreSQL Error: database is being accessed by other users

Related Posts:

  1. How to find list of active sessions/connections in PostgreSQL database
  2. How to rename PostgreSQL User
  3. PostgreSQL ERROR: syntax error at or near “VARCHAR”
  4. psql: error: FATAL: role is not permitted to log in

How to find list of active sessions/connections in PostgreSQL database

In this article, we will see how to find list of active sessions/connections in PostgreSQL database.

We can find list of active/inactive sessions/connections by querying against PostgreSQL system view pg_stat_activity.
Continue reading How to find list of active sessions/connections in PostgreSQL database

Related Posts:

  1. How to find currently logged in users in PostgreSQL
  2. How to get list of users in PostgreSQL
  3. How to take backup and restore a PostgreSQL Database
  4. PostgreSQL Create User

How to get list of sessions on PostgreSQL database

In this article, we will see how to get list of sessions on PostgreSQL database. We will see all sessions in PostgreSQL and sessions specific to the database. We can get session by running queries against pg_stat_activity.

Syntax to get list of sessions on PostgreSQL database: Continue reading How to get list of sessions on PostgreSQL database

Related Posts:

  1. How to check whether a user is connected to PostgreSQL or not
  2. How to find long running queries in PostgreSQL
  3. How to find which queries are running PostgreSQL
  4. How to save query result to a file in PostgreSQL