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

0 vote230 views1 answer
View to table
SQL
0 vote194 views1 answer
Hibernate with springboot mysql
SQL
0 vote194 views1 answer
Sql column contains special character
SQL
0 vote254 views1 answer
Postgresql conectar
SQL
1 vote191 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote187 views1 answer
Sql find leading space
SQL
103 votes2.5K views1 answer
Like sql
SQL
1 vote189 views1 answer
Mariadb alter user host
SQL
3 votes184 views2 answers
Oracle synonym
SQL
0 vote187 views1 answer
How to reset AI in sql
SQL