May 2018
Intermediate to advanced
576 pages
30h 25m
English
When a backend executes the pg_terminate_backend(pid) function, it sends a signal, SIGTERM, to the backend as an argument after verifying that the process identified by the argument pid is actually a PostgreSQL backend.
The backend receiving this signal stops whatever it is doing, and terminates it in a controlled way.
The client using that backend loses the connection to the database. Depending on how the client application is written, it may silently reconnect, or it may show an error to the user.