|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated: Sun Apr 24 07:27:43 EDT 2005</P> |
| 13 | +<P>Last updated: Sun Apr 24 07:48:48 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>) |
@@ -115,6 +115,7 @@ <H2 align="center">Operational Questions</H2> |
115 | 115 | does not exist" errors when accessing temporary tables in PL/PgSQL |
116 | 116 | functions?<BR> |
117 | 117 | <Ahref="#4.20">4.20</A>) What encryption options are available?<BR> |
| 118 | +<Ahref="#4.21">4.21</A>) What replication solutions are available?<BR> |
118 | 119 |
|
119 | 120 |
|
120 | 121 | <HR> |
@@ -984,5 +985,18 @@ <H3><A name="4.20">4.20</A>) What encryption options are available? |
984 | 985 | <LI>The server can also run using an encrypted file system.</LI> |
985 | 986 | </UL> |
986 | 987 |
|
| 988 | +<H3><Aname="4.21">4.21</A>) What replication solutions are available? |
| 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. 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> |
987 | 1001 | </BODY> |
988 | 1002 | </HTML> |