Answers for "drop session postgresql"

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 "drop session postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "drop session postgresql"

Code answers related to "drop session postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "drop session postgresql"

Code answers related to "drop session postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us