Postgres killing connections on db

SELECT 
    pg_terminate_backend(pid) 
FROM 
    pg_stat_activity 
WHERE 
    -- don't kill my own connection!
    pid <> pg_backend_pid()
    -- don't kill the connections to other databases
    AND datname = 'database_name'
    ;

Source: stackoverflow.com

Similar codes

3 votes101 views2 answers
Find the median in sql
SQL
5 votes94 views1 answer
Mysql add user with all privileges
SQL
0 vote114 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
-1 vote115 views1 answer
Add bool column in sql
SQL
0 vote112 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
2 votes102 views1 answer
Mysql sysdate
SQL
0 vote110 views1 answer
Wordpress sql change site url
SQL
0 vote100 views1 answer
How to reset AI in sql
SQL
2 votes116 views2 answers
Sqlalchemy return id after insert
SQL
0 vote109 views1 answer
How to put value in parameters in mysqldataadapter
SQL