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

9 votes265 views3 answers
Mysql get last id
SQL
11 votes258 views1 answer
Reset identity sql server
SQL
0 vote278 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote282 views1 answer
Pl sql constraint user function
SQL
0 vote292 views1 answer
Mysql timediff
SQL
0 vote282 views1 answer
Complete date is 1 year or not sql server
SQL
2 votes298 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
7 votes289 views3 answers
Select latest entry in sql table
SQL
0 vote300 views1 answer
Repeatable read trong sql server
SQL
23 votes277 views3 answers
Mysqldump
SQL