Geek asks and answers

How to handle distributed transaction in postgresql?

Can anyone kindly tell me how to handle a distributed transaction in postgresql, also called "XA"? Are there any resources? Thanks so much for any answer.

+3
source share
1 answer

You seem a little confused. Typically, database systems support two concepts of distributed transaction types:

  • Proprietary distributed transactions and
  • XA operations.

. Postgres dblink_exec. , . Postgres , RDBMS . , . postgres rdbms .

On the other hand, XA transactions are managed by an external transaction manager (TM), and each of the participating databases has an XA resource role that attracts a transaction manager. The RDBMS can no longer decide when to complete a transaction. This is the task of the XA Transaction Manager. It uses the 2PC protocol to ensure that changes are applied or rolled back sequentially in the databases.

On some operating systems, such as windows, a transaction manager is part of the operating system for others. Typically, java comes with a transaction manager, and the appropriate data source must be configured to use XA.

+5
source

More articles:


All Articles