O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pushing users off the system

Sometimes, we may need to remove groups of users from the database server for various operational reasons. Here's how.

How to do it…

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.

Note

Some of the columns used in this recipe had a different name in version 9.1 and before:

  • pid was called procpid
  • query was called current_query

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required