posts/2012/11/13/list-and-disconnect-postgresql-db-sessions/

[giscus[bot]]

posts/2012/11/13/list-and-disconnect-postgresql-db-sessions/

Some times it is necessary to terminate a PostgreSQL query and connection. This can be very helpful when you have a run away command or script. It can also be helpful if your application has submitted a query to the backend that has caused everything to grind to a halt. Fortunately, postgres comes to the rescue and provides a few helpful commands that will allow you to cancel the query from the database and optionally terminate the user or application's connection.

https://www.devopsderek.com/posts/2012/11/13/list-and-disconnect-postgresql-db-sessions/

[derektamsen]

Thanks this was helpful.

Martin

[derektamsen]

Thanks Derek

eriksaunier

[derektamsen]

In Postgres 9.3, pg_terminate_backend do exist but not pg_cancel_backend. Thanks Derek. :-)

David Pérez