how to stop all connections to a psql 12 database 3f

Solutions on MaxInterview for how to stop all connections to a psql 12 database 3f by the best coders in the world

showing results for - "how to stop all connections to a psql 12 database 3f"

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

similar questions

sql server allow remote connections stop psql server windows check connections to database postgres postgresql transaction discard all postgres remove database mysql allow only local connections psql connections mysql allow remote connections drop database using terminal postgres view and kill postgresql connections to database postgresql allow remote connections postgres killing connections on db

queries leading to this page

drop all connections postgresql psql server prevent connections to other database postgres close all connections sql kill all postgres connections cancel connections psql kill all connections psql postgresql delete all connections psql server prevent connections close all connections postgres how to stop all connections to a psql 12 database 3f