Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to stop all connections to a psql 12 database?

# Works for psql 12
select pg_terminate_backend(pid) from pg_stat_activity where datname='<db_name>';
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #stop #connections #psql
ADD COMMENT
Topic
Name
8+2 =