Answers for "postgres drop database with connections"

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 drop database with connections"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres drop database with connections"

Code answers related to "postgres drop database with connections"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres drop database with connections"

Code answers related to "postgres drop database with connections"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us