diff options
author | Bruce Momjian <bruce@momjian.us> | 2005-04-30 03:52:23 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2005-04-30 03:52:23 +0000 |
commit | ef1b4fbb568b783fbbe2800b66c70dafc94013fb (patch) | |
tree | 5db0e82bda22f14f5e8f772ee3f9e039d29cabc5 /doc/FAQ | |
parent | 3a694bb0a16fea1662f1ffd31506a72effdd4a93 (diff) | |
download | postgresql-ef1b4fbb568b783fbbe2800b66c70dafc94013fb.tar.gz postgresql-ef1b4fbb568b783fbbe2800b66c70dafc94013fb.zip |
Update replication FAQ.
Christopher Browne
Diffstat (limited to 'doc/FAQ')
-rw-r--r-- | doc/FAQ | 27 |
1 files changed, 17 insertions, 10 deletions
@@ -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. |