Is it possible for Postgresql to interact with Transaction Manager (TM like Tuxedo) as a Ressource Manager (RM) ?
Hi.
I'm trying to understand if it is possible to link Postgresql with a
Transaction Manager like Tuxedo.
A transaction manager is XA compliant.
For example, Tuxedo TMS server implement this interface.
If you want to use Tuxedo with Oracle as a Ressource Manager, you need to :
- Define an entry in RM file which describe, for each Ressource Manager, XA
libraries to use.
- Compile and link the TMS module with buildtms procedure with the entry as
parameter.
I would like to know if there is an XA librarie in the Postgresql
distribution.
Thank you for your help.
Regards,
Alain.
alain.bruneau@acoss.fr wrote:
Hi.
I'm trying to understand if it is possible to link Postgresql with a
Transaction Manager like Tuxedo.
Nope. At a minimum PostgreSQL would first have to expose a
two-phase commit API before an XA library could be written.
There was work done in this area:
but it will be interesting to see if it ever sees the light of day.
Mike Mascari
mascarm@mascari.com