Comando para derrubar todas as conexões no postgreSQL.txt

PostgreSQL 9.6 e posterior:

SELECT pg_terminate_backend(pg_stat_activity.pid)

FROM pg_stat_activity
 
WHERE pg_stat_activity.datname = 'NOME_DA_BASE'
 
AND pid <> pg_backend_pid();





PostgreSQL 9.0 e anterior:

SELECT pg_terminate_backend(pg_stat_activity.procpid)

FROM pg_stat_activity 

WHERE pg_stat_activity.datname = 'NOME_DA_BASE'
 
AND procpid <> pg_backend_pid();