Thread: 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:


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=ead6cfa512d740f2&seekm=87wuns3lwh.fsf%40mailbox.samurai.com#link6

but it will be interesting to see if it ever sees the light of day.

Mike Mascari
mascarm@mascari.com