Online Documentation for SQL Manager for PostgreSQL

Managing Prepared Transactions

The Prepared Transactions tab of the Server Status viewer allows you to browse the list of outstanding prepared transactions. Prepared transactions are an aspect of Two Phase Commit (2PC), used in distributed transaction managers. Normally, prepared transactions are handled by the transaction manager. In case of a failure, it might be necessary to commit or rollback a transaction manually; use the Commit transaction or Rollback transaction items on the general bar to do that.

Note: This tab is only available for running PostgreSQL server version 8.1 or higher.

The list displays the prepared transactions as a grid with the following columns: Transaction, Global ID, Prepare Time, Owner, Database. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Right-click an item within the list to call the context menu allowing you to refresh the list or commit/rollback a transaction.

Transaction management tools are also available through the Navigation bar of the Server Status viewer. Using the Navigation bar you can also set the Refresh Rate for the transactions list.