Re: Roadmap for Database Kernel XA Support

I think XA will be in 8.1 and 8.1 might be a year away from release.

---------------------------------------------------------------------------

Horst G. Reiterer wrote:
> Hi,
>
> a native application of ours is based on distributed transactions and thus
> requires all databases to provide an XA interface so that an XA-compliant
> DTM (e.g. Tuxedo) can do its work.
>
> I read in the JDBC driver FAQ (I'm not interested in the JDBC driver itself)
> at http://jdbc.postgresql.org/documentation/faq.html that XA Support for the
> database is scheduled for 8.1, does that still hold true (if yes, do you
> have an early 8.1 ETA)?
>
> >From my understanding, supporting XA would mean to
>
> - provide an XA library implementing the XA interface
> as described in the X/Open XA specification at
> http://www.opengroup.org/publications/catalog/c193.htm
>
> - support commit preparation (the process of persisting
> transactional changes without actually committing the
> transaction so that a later commit is guaranteed to
> succeed should the log be available in a consistent
> state)
>
> - [optional] allow a Point-In-Time Recovery (PITR) based
> on an XA XID rather than an internal transaction id or
> time specification. This functionality would enable
> a consistent recovery of multiple, cooperating
> PostgreSQL databases.
>
> Judging from a one day old CVS checkout, neither of these aspects have been
> addressed at this time or are currently being worked on. If at all possible,
> please provide me with an update on the current status and plan on
> implementing XA support. Can you estimate the time (e.g. in man-days) and
> implementation complexity of integrating this functionality?
>
> Thanks in advance for any insights in this respect!
>
> Cheers,
>
> Horst.
>
> P.S.: The 8.0 release candidate rocks, PITR works flawlessly, without a
> hitch. Thanks for your efforts!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073