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 vote354 views1 answer
Wordpress make wp user in db
SQL
0 vote314 views1 answer
Mysql select smaller of two values
SQL
16 votes325 views1 answer
Mysql reset auto increment value
SQL
0 vote315 views1 answer
Group by max date
SQL
6 votes308 views2 answers
Mysql get yesterday
SQL
0 vote353 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote329 views1 answer
Command line mysql xampp
SQL
0 vote317 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote298 views1 answer
Sql get guid
SQL
0 vote314 views1 answer
Mysql error 1452
SQL