|
1 | 1 |
|
2 | 2 | Frequently Asked Questions (FAQ) for PostgreSQL
|
3 | 3 |
|
4 |
| - Last updated: Sun Apr 2407:57:14 EDT 2005 |
| 4 | + Last updated: Sun Apr 2408:01:19 EDT 2005 |
5 | 5 |
|
6 | 6 | Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
|
7 | 7 |
|
|
763 | 763 |
|
764 | 764 | Though "replication" is a single term, there are two major replication
|
765 | 765 | technologies. Multi-master replication allows read/write queries to be
|
766 |
| - sent to multiple replicated computers.Thiscapability has a serious |
767 |
| - performance impact. Pgcluster is the most popular such solution |
768 |
| - available for PostgreSQL. Master-slave replication allows a single |
769 |
| - master to receive read/write queries, with slaves able to accept only |
770 |
| - read/SELECT queries. The most popular master-slave PostgreSQL |
771 |
| - replication solution is Slony. There are also commercial and |
772 |
| - hardware-based replication solutions available. |
| 766 | + sent to multiple replicated computers.Using thiscapability has a |
| 767 | +seriousperformance impact. Pgcluster is the most popular such |
| 768 | +solutionavailable for PostgreSQL. Master-slave replication allows a |
| 769 | +singlemaster to receive read/write queries, with slaves able to |
| 770 | +accept onlyread/SELECT queries. The most popular master-slave |
| 771 | +PostgreSQLreplication solution is Slony. There are also commercial |
| 772 | +andhardware-based replication solutions available. |