Answers for "close open connection postgres"

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 "close open connection postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "close open connection postgres"

Code answers related to "close open connection postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "close open connection postgres"

Code answers related to "close open connection postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us