Home/ Questions/"ERROR Database Is Being Accessed By Other Users DETAIL There Is 1 Other Session Using The Database" - How to fix?
Next
In Process
Ira O'Brien
  • 17
Asked: 2022-04-21T07:47:27+00:00 In:

“ERROR Database Is Being Accessed By Other Users DETAIL There Is 1 Other Session Using The Database” – How to fix?

  • 17

. Advertisement .

..3..

. Advertisement .

..4..

I get the error “database is being accessed by other users DETAIL: There is 1 other session using the database.”

Please give me some advice to fix it.

♦ Suggestions of ITtutoria Team
This command line can help you to solve the problem

sudo service postgresql restart
Share

2 Answers

  1. Let’s explore this topic by examining my simple solution

    sudo service postgresql restart
    • 22

  2. In case you expect more than one maximum this will work

    PostgresVersion >=9.2
​
SELECT 
   pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE
   pg_stat_activity.datname = 'name_of_database_to_be_disconnected'
AND pid <> pg_backend_pid()
    • 7

Leave an answer

You must login to add an answer.

Need An Account,