PostgreSQL 11 Administration Cookbook

Getting ready

First, check the setting of max_prepared_transactions:

SHOW max_prepared_transactions;

If your setting is more than zero, then check whether you have any prepared transactions. As an example, you may find something like the following:

postgres=# SELECT * FROM pg_prepared_xacts;-[ RECORD 1 ]------------------------------transaction | 459812gid         | prep1prepared    | 2017-04-11  13:21:51.912374+01owner       | postgresdatabase    | postgres

Here, gid (global identifier) will usually be automatically generated.