Answers for "postgres 13 terminate connection before dropping database"

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'
    ;

Posted by: Guest on June-22-2020

Code answers related to "postgres 13 terminate connection before dropping database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres 13 terminate connection before dropping database"

Code answers related to "postgres 13 terminate connection before dropping database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres 13 terminate connection before dropping database"

Code answers related to "postgres 13 terminate connection before dropping database"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us