Postgres easy kick users
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE datname='YourDB';It will close the connections to YourDB.
Written by Jaco Groenewald
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Postgres
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#