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 vote146 views1 answer
Sp in sql server
SQL
0 vote152 views1 answer
How to subquey to do not load in live database in
SQL
16 votes145 views1 answer
CTE statement sql server
SQL
2 votes167 views1 answer
Insert from table tsql
SQL
0 vote129 views1 answer
Excute raw query
SQL
0 vote130 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
5 votes137 views1 answer
How to check nls format in oracle
SQL
0 vote139 views1 answer
Sql select all tables from database change url
SQL
0 vote166 views1 answer
How to find unique element in sql
SQL
0 vote95 views1 answer
Alter session set nls_language french
SQL