|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated:Sun Apr24 08:01:19 EDT 2005</P> |
| 13 | +<P>Last updated:Fri Apr29 23:51:45 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,16 +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 | | -<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.<Ahref="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 | | -<Ahref="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<Ahref="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.<Ahref="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> |
1001 | 1007 | </BODY> |
1002 | 1008 | </HTML> |