Transaction manager

PostgreSQL needs an external transaction manager for distributed transactions.

Theory

Transaction types

Transactions come in three types:

Non-Distributed transactions

manipulate or query only a single database (the local database where the user is logged in).

Remote transactions

manipulate or query only a remotely located database.

Distributed transactions

manipulate or query more than one node in a distributed database.