Skip to content

Commit ef1b4fb

Browse files
committed
Update replication FAQ.
Christopher Browne
1 parent 3a694bb commit ef1b4fb

File tree

2 files changed

+35
-22
lines changed

2 files changed

+35
-22
lines changed

doc/FAQ

Lines changed: 17 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Sun Apr 24 08:01:19 EDT 2005
4+
Last updated: Fri Apr 29 23:51:45 EDT 2005
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

@@ -761,12 +761,19 @@
761761

762762
4.21) What replication solutions are available?
763763

764-
Though "replication" is a single term, there are two major replication
765-
technologies. Multi-master replication allows read/write queries to be
766-
sent to multiple replicated computers. Using this capability has a
767-
serious performance impact. Pgcluster is the most popular such
768-
solution available for PostgreSQL. Master-slave replication allows a
769-
single master to receive read/write queries, with slaves able to
770-
accept only read/SELECT queries. The most popular master-slave
771-
PostgreSQL replication solution is Slony. There are also commercial
772-
and hardware-based replication solutions available.
764+
Though "replication" is a single term, there are several technologies
765+
for doing replication, with advantages and disadvantages for each.
766+
767+
Master/slave replication allows a single master to receive read/write
768+
queries, while slaves can only accept read/SELECT queries. The most
769+
popular freely available master-slave PostgreSQL replication solution
770+
is Slony-I.
771+
772+
Multi-master replication allows read/write queries to be sent to
773+
multiple replicated computers. This capability also has a severe
774+
impact on performance due to the need to synchronize changes between
775+
servers. Pgcluster is the most popular such solution freely available
776+
for PostgreSQL.
777+
778+
There are also commercial and hardware-based replication solutions
779+
available supporting a variety of replication models.

doc/src/FAQ/FAQ.html

Lines changed: 18 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated: Sun Apr 24 08:01:19 EDT 2005</P>
13+
<P>Last updated: Fri Apr 29 23:51:45 EDT 2005</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<A href=
1616
"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)
@@ -987,16 +987,22 @@ <H3><A name="4.20">4.20</A>) What encryption options are available?
987987

988988
<H3><A name="4.21">4.21</A>) What replication solutions are available?
989989
</H3>
990-
<P>Though "replication" is a single term, there are two major replication
991-
technologies. Multi-master replication allows read/write queries to be
992-
sent to multiple replicated computers. Using this capability has a
993-
serious performance impact. <A href="http://pgfoundry.org/projects/pgcluster/">
994-
Pgcluster</A> is the most popular such solution available for PostgreSQL.
995-
Master-slave replication allows a single master to receive read/write
996-
queries, with slaves able to accept only read/<SMALL>SELECT</SMALL> queries.
997-
The most popular master-slave PostgreSQL replication solution is
998-
<A href="http://gborg.postgresql.org/project/slony1/projdisplay.php">
999-
Slony</A>. There are also commercial and hardware-based replication
1000-
solutions available.</P>
990+
<P>Though "replication" is a single term, there are several technologies
991+
for doing replication, with advantages and disadvantages for each.</P>
992+
993+
<P>Master/slave replication allows a single master to receive read/write
994+
queries, while slaves can only accept read/<SMALL>SELECT</SMALL> queries.
995+
The most popular freely available master-slave PostgreSQL replication
996+
solution is <A href="http://gborg.postgresql.org/project/slony1/projdisplay.php">
997+
Slony-I</A>.</P>
998+
999+
<P>Multi-master replication allows read/write queries to be sent to
1000+
multiple replicated computers. This capability also has a severe
1001+
impact on performance due to the need to synchronize changes between
1002+
servers. <A href="http://pgfoundry.org/projects/pgcluster/">Pgcluster</a>
1003+
is the most popular such solution freely available for PostgreSQL.</P>
1004+
1005+
<P>There are also commercial and hardware-based replication solutions
1006+
available supporting a variety of replication models.</P>
10011007
</BODY>
10021008
</HTML>

0 commit comments

Comments
 (0)