Sometimes, we may need to remove groups of users from the database server for various operational reasons. Here's how.
You can terminate a user's session with the
pg_terminate_backend() function included with PostgreSQL. That function takes the
PID, or the process ID, of the user's session on the server. This process is known as the backend, and it is a different system process from the program that runs the client.
Some of the columns used in this recipe had a different name in version 9.1 and before:
The queries in this recipe are written for PostgreSQL 9.4, the most recent stable version at the time of writing this book. They work without changes ...