2

I would like to know if it is possible to use Postgres as a database backend with transaction monitors like Oracle Tuxedo or Microfocus Enterprise server on Linux.

This can be possible if postgres provides an XA compilant ressource manager...

I have searched on postgres website but couldn't find any relevant information about such support.

Thanks in advance.

y.chraibi
  • 66
  • 4
  • Postgres supports 2PC via [prepared transactions](https://www.postgresql.org/docs/current/static/sql-prepare-transaction.html), and the [JDBC driver](https://jdbc.postgresql.org/documentation/faq.html#xa) claims to be XA compliant (or near enough). – Nick Barnes Jul 28 '17 at 03:40

2 Answers2

2

psqlODBC provides an XA resource manager.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778
  • Thanks Craig. In the documentation, I see XA mentionned only in Windows context... Do you confirm it is supported also on Linux version of the driver? – y.chraibi Jul 28 '17 at 15:58
  • Yes, it's there, `pgxalib` – Craig Ringer Jul 29 '17 at 07:42
  • Does anyone have an example to make Postgres work as Resource manager with Tuxedo as Transaction manager . I am trying on Linux , using C++ applications. – N3Xg3N Feb 08 '22 at 17:48
0

Enduro/X Middleware (almost clone to Tuxedo) ships with PostgreSQL XA driver for libpq and ecpg apis. Sample usage can be seen under https://github.com/endurox-dev/endurox/tree/master/atmitest/test067_postgres

Madars Vi
  • 947
  • 9
  • 12