Re: Transactional support across multiple machines...

On 17.11.2010 20:40, Maciek Sakrejda wrote:
> Prepared transactions:
> http://www.postgresql.org/docs/9.0/static/sql-prepare-transaction.html

Yeah, two-phase commit is the usual solution. But you shouldn't usually
try to implement that yourself, you should pick an existing Transaction
Manager. Java application servers usually include one, so if you're
using an application server, just configure your application to use XA
connections and let the app server handle the two-phase commit for you.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com