akhdaniel/terminat posgresql session.md

Created July 26, 2021 04:01

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/akhdaniel/126d3c74ed7739cd2126f248845433c2.js"></script>
Save akhdaniel/126d3c74ed7739cd2126f248845433c2 to your computer and use it in GitHub Desktop.

Raw

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