aboutsummaryrefslogtreecommitdiff
path: root/doc/FAQ
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2005-04-30 03:52:23 +0000
committerBruce Momjian <bruce@momjian.us>2005-04-30 03:52:23 +0000
commitef1b4fbb568b783fbbe2800b66c70dafc94013fb (patch)
tree5db0e82bda22f14f5e8f772ee3f9e039d29cabc5 /doc/FAQ
parent3a694bb0a16fea1662f1ffd31506a72effdd4a93 (diff)
downloadpostgresql-ef1b4fbb568b783fbbe2800b66c70dafc94013fb.tar.gz
postgresql-ef1b4fbb568b783fbbe2800b66c70dafc94013fb.zip
Update replication FAQ.
Christopher Browne
Diffstat (limited to 'doc/FAQ')
-rw-r--r--doc/FAQ27
1 files changed, 17 insertions, 10 deletions
diff --git a/doc/FAQ b/doc/FAQ
index d84f56a4a16..e0eaffd4204 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.