scisco/postgres.md

Created May 13, 2016 15:29

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/scisco/879c9827912dd59c5ff2ee58ff6e87a6.js"></script>
Save scisco/879c9827912dd59c5ff2ee58ff6e87a6 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

Scisco created this gist May 13, 2016.

postgres.md

-Original file line number
+Diff line change
@@ -0,0 +1,11 @@
+    ```
+    SELECT
+        pg_terminate_backend(pid)
+    FROM
+        pg_stat_activity
+    WHERE
+        -- don't kill my own connection!
+        pid <> pg_backend_pid()
+        -- don't kill the connections to other databases
+        AND datname = 'databasename';
+    ```