Programming/Database2 PostgreSQL - Kill connection SELECT pg_terminate_backend(pg_stat_activity.procpid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'TARGET_DB'; 2012. 2. 20. PostgreSQL http://www.davidpashley.com/articles/postgresql-user-administration.html PostgreSQL has a powerful user authentication and access control system, but for a newcomer, it can seem confusing and overwhelming. In this article I hope to explain how to manage user and permissions with ease. Note Since this article was written, the user scheme was overhauled for 8.3. While most of this article is still.. 2012. 2. 20. 이전 1 다음