|
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. |