|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated: Fri Apr 29 23:51:45 EDT 2005</P> |
| 13 | +<P>Last updated: Fri Apr 29 23:53:16 EDT 2005</P> |
14 | 14 |
|
15 | 15 | <P>Current maintainer: Bruce Momjian (<Ahref= |
16 | 16 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) |
@@ -987,20 +987,22 @@ <H3><A name="4.20">4.20</A>) What encryption options are available? |
987 | 987 |
|
988 | 988 | <H3><Aname="4.21">4.21</A>) What replication solutions are available? |
989 | 989 | </H3> |
| 990 | + |
990 | 991 | <P>Though "replication" is a single term, there are several technologies |
991 | 992 | for doing replication, with advantages and disadvantages for each.</P> |
992 | 993 |
|
993 | 994 | <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<Ahref="http://gborg.postgresql.org/project/slony1/projdisplay.php"> |
| 995 | + queries, while slaves can only accept read/<SMALL>SELECT</SMALL> |
| 996 | + queries. The most popular freely available master-slave PostgreSQL |
| 997 | + replication solution is<A |
| 998 | +href="http://gborg.postgresql.org/project/slony1/projdisplay.php"> |
997 | 999 | Slony-I</A>.</P> |
998 | 1000 |
|
999 | 1001 | <P>Multi-master replication allows read/write queries to be sent to |
1000 | | - multiple replicated computers. This capability also has a severe |
1001 | | -impacton performance due to the need to synchronize changes between |
1002 | | -servers.<Ahref="http://pgfoundry.org/projects/pgcluster/">Pgcluster</a> |
1003 | | -is themost popular such solution freely available for PostgreSQL.</P> |
| 1002 | + multiple replicated computers. This capability also has a severe impact |
| 1003 | + on performance due to the need to synchronize changes between servers. |
| 1004 | +<Ahref="http://pgfoundry.org/projects/pgcluster/">Pgcluster</a> is the |
| 1005 | + most popular such solution freely available for PostgreSQL.</P> |
1004 | 1006 |
|
1005 | 1007 | <P>There are also commercial and hardware-based replication solutions |
1006 | 1008 | available supporting a variety of replication models.</P> |
|