andilabs
9/6/2017 - 2:48 PM

kill all connections to postgres database

kill all connections to postgres database

kill_psql.sql
content_copyfile_download
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'YOUR_DATABASE_NAME'
  AND pid <> pg_backend_pid();