How to disable the deadlock process in PostgreSQL, postgresql Process

How to disable the deadlock process in PostgreSQL, postgresql Process

The PostgreSQL database used has no information. Google had to proceed.

Finally, a solution was found in an English forum.

As follows:

1. Retrieve the ID of the deadlock Process

Copy codeThe Code is as follows:
SELECT * FROM pg_stat_activity WHERE datname = 'deadlock database id ';

In the retrieved field, the [wating] field, the data t, is the deadlock process. Find the value of the corresponding procpid column.

2. Kill the process

Copy codeThe Code is as follows:
SELECT pg_cancel_backend ('procpid value of the deadlocked data ');

Result: The SQL statement is successfully executed after the table is updated again.
 
Ps: Find the function list of the database and find that the pg_terminate_backend () function can also kill the process.

Content provided on the official website: http://www.postgresql.org/docs/9.0/static/functions-admin.html