how to stop all connections to a psql 12 database?

RicHincapie answered on August 11, 2021 Popularity 8/10 Helpfulness 9/10

answer how to stop all connections to a psql 12 database?

Comment

# Works for psql 12
select pg_terminate_backend(pid) from pg_stat_activity where datname='<db_name>';

Popularity 8/10 Helpfulness 9/10 Language sql

Tags: psql sql

Link to this answer
Share Copy Link

Contributed on Aug 11 2021

RicHincapie

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'db_name';

Popularity 9/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on May 09 2022

Abobakr

0 Answers Avg Quality 2/10

Comment

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'your_database_name';

Popularity 6/10 Helpfulness 1/10 Language

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10