From 8a6193333cf1028384a83ef4e75310ea82ae000f Mon Sep 17 00:00:00 2001 From: Bruce Momjian <bruce@momjian.us> Date: Thu, 16 Nov 2006 21:45:25 +0000 Subject: [PATCH] Mention two-phase commit for having all transactions commit on all servers. --- doc/src/sgml/failover.sgml | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/failover.sgml b/doc/src/sgml/failover.sgml index 618d0bea9d..63b4cf5175 100644 --- a/doc/src/sgml/failover.sgml +++ b/doc/src/sgml/failover.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/failover.sgml,v 1.8 2006/11/16 21:43:33 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/failover.sgml,v 1.9 2006/11/16 21:45:25 momjian Exp $ --> <chapter id="failover"> <title>Failover, Replication, Load Balancing, and Clustering Options</title> @@ -192,9 +192,13 @@ is because each server operates independently, and because SQL queries are broadcast (and not actual modified rows). If this is unacceptable, applications must query such values from a - single server and then use those values in write queries. Also, - care must be taken that all transactions either commit or abort - on all servers Pgpool is an example of this type of replication. + single server and then use those values in write queries. + Also, care must be taken that all transactions either commit + or abort on all servers, perhaps using two-phase commit (<xref + linkend="sql-prepare-transaction" + endterm="sql-prepare-transaction-title"> and <xref + linkend="sql-commit-prepared" endterm="sql-commit-prepared-title">. + Pgpool is an example of this type of replication. </para> </listitem> </varlistentry> -- 2.49.0