From ef1b4fbb568b783fbbe2800b66c70dafc94013fb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 30 Apr 2005 03:52:23 +0000 Subject: [PATCH] Update replication FAQ. Christopher Browne --- doc/FAQ | 27 +++++++++++++++++---------- doc/src/FAQ/FAQ.html | 30 ++++++++++++++++++------------ 2 files changed, 35 insertions(+), 22 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index d84f56a4a1..e0eaffd420 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sun Apr 24 08:01:19 EDT 2005 + Last updated: Fri Apr 29 23:51:45 EDT 2005 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -761,12 +761,19 @@ 4.21) What replication solutions are available? - Though "replication" is a single term, there are two major replication - technologies. Multi-master replication allows read/write queries to be - sent to multiple replicated computers. Using this capability has a - serious performance impact. Pgcluster is the most popular such - solution available for PostgreSQL. Master-slave replication allows a - single master to receive read/write queries, with slaves able to - accept only read/SELECT queries. The most popular master-slave - PostgreSQL replication solution is Slony. There are also commercial - and hardware-based replication solutions available. + Though "replication" is a single term, there are several technologies + for doing replication, with advantages and disadvantages for each. + + Master/slave replication allows a single master to receive read/write + queries, while slaves can only accept read/SELECT queries. The most + popular freely available master-slave PostgreSQL replication solution + is Slony-I. + + Multi-master replication allows read/write queries to be sent to + multiple replicated computers. This capability also has a severe + impact on performance due to the need to synchronize changes between + servers. Pgcluster is the most popular such solution freely available + for PostgreSQL. + + There are also commercial and hardware-based replication solutions + available supporting a variety of replication models. diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 7c5dcaacdf..b88bc9cfd8 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sun Apr 24 08:01:19 EDT 2005

+

Last updated: Fri Apr 29 23:51:45 EDT 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -987,16 +987,22 @@ length

4.21) What replication solutions are available?

-

Though "replication" is a single term, there are two major replication - technologies. Multi-master replication allows read/write queries to be - sent to multiple replicated computers. Using this capability has a - serious performance impact. - Pgcluster is the most popular such solution available for PostgreSQL. - Master-slave replication allows a single master to receive read/write - queries, with slaves able to accept only read/SELECT queries. - The most popular master-slave PostgreSQL replication solution is - - Slony. There are also commercial and hardware-based replication - solutions available.

+

Though "replication" is a single term, there are several technologies + for doing replication, with advantages and disadvantages for each.

+ +

Master/slave replication allows a single master to receive read/write + queries, while slaves can only accept read/SELECT queries. + The most popular freely available master-slave PostgreSQL replication + solution is + Slony-I.

+ +

Multi-master replication allows read/write queries to be sent to + multiple replicated computers. This capability also has a severe + impact on performance due to the need to synchronize changes between + servers. Pgcluster + is the most popular such solution freely available for PostgreSQL.

+ +

There are also commercial and hardware-based replication solutions + available supporting a variety of replication models.

-- 2.40.0