Answers for "pgadmin postgres ERROR: database is being accessed by other users"

pgadmin postgres ERROR: database is being accessed by other users

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()

Posted by: Guest on November-28-2020

Code answers related to "pgadmin postgres ERROR: database is being accessed by other users"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "pgadmin postgres ERROR: database is being accessed by other users"

Code answers related to "pgadmin postgres ERROR: database is being accessed by other users"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "pgadmin postgres ERROR: database is being accessed by other users"

Code answers related to "pgadmin postgres ERROR: database is being accessed by other users"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us