diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-11-16 21:45:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-11-16 21:45:25 +0000 |
| commit | 8a6193333cf1028384a83ef4e75310ea82ae000f (patch) | |
| tree | fd4e4f5247413c4ef2fdb852ec6368cf30839179 | |
| parent | a1e5b5c832db3afa0a10610b219cccc84e7e0a2a (diff) | |
Mention two-phase commit for having all transactions commit on all servers.
| -rw-r--r-- | doc/src/sgml/failover.sgml | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/doc/src/sgml/failover.sgml b/doc/src/sgml/failover.sgml index 618d0bea9da..63b4cf51759 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> |