CODE EXAMPLE FOR SQL

postgresql stop all connections

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