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 is known as the backend, and is a different system process from the program that runs the client.
To find out the
pid of a user, we can look at the view
pg_stat_activity. We can use that in a query like the following:
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE ...
There's a couple of things to note if you run that query, which are as follows:
WHEREclause matches no sessions, ...