Re: 2-phase commit
Rod Taylor <rbt@rbt.ca>
From: Rod Taylor <rbt@rbt.ca>
To: Andrew Sullivan <andrew@libertyrms.info>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-09-26T21:15:37Z
Lists: pgsql-hackers
> The first problem is the restart/rejoin problem. When a 2PC member > goes away, it is supposed to come back with all its former locks and > everything in place, so that it can know what to do. This is also > extremely tricky, but I think the answer is sort of easy. A member > which re-joins without crashing (that is, it has open transactions, I think you may be confusing 2PC with replication. PostgreSQLs 2PC implementation should follow enough of the XA rules to play nice in a mixed environment where something else is managing the transactions (application servers are becoming more common all the time). As far as inter-PostgreSQL replication / queries are concerned we can choose whatever semantics we like -- just realize that they are 2 different problems.