Answers for "psql connection remove"

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

Source

Code answers related to "psql connection remove"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "psql connection remove"

Code answers related to "psql connection remove"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "psql connection remove"

Code answers related to "psql connection remove"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us