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

7 votes319 views1 answer
Forge server hosting
SQL
0 vote304 views7 answers
10 random questions use python and SQL
SQL
0 vote278 views1 answer
Mysqli or pdo
SQL
22 votes328 views3 answers
Join three tables sql
SQL
4 votes316 views1 answer
Wilayah indonesia sql
SQL
0 vote332 views2 answers
How to find sql server agent jobs related to a database
SQL
-2 votes334 views1 answer
Mysql see users and passwords
SQL
0 vote324 views1 answer
Alter table fulltext
SQL
0 vote327 views2 answers
Postgresql get last day of month
SQL
0 vote378 views1 answer
Sql server query all database objects
SQL