What replication solutions are available?
814 815 Though “replication” is a single term, there are several technologies 816 for doing replication, with advantages and disadvantages for each. 817 818 Master/slave replication allows a single master to receive read/write 819 queries, while slaves can only accept read/SELECT queries. The most 820 popular freely available master-slave PostgreSQL replication solution 821 is Slony-I. 822 823 Multi-master replication allows read/write queries to be sent to 824 multiple replicated computers. This capability also has a severe 825 impact on performance due to the need to synchronize changes between 826 servers. Pgcluster is the most popular such solution freely available 827 for PostgreSQL. 828 829 There are also commercial and hardware-based replication solutions 830 available supporting a variety of replication models.
763763 764 Though “replication” is a single term, there are two major replication 765 technologies. Multi-master replication allows read/write queries to be 766 sent to multiple replicated computers. Using this capability has a 767 serious performance impact. Pgcluster is the most popular such 768 solution available for PostgreSQL. Master-slave replication allows a 769 single master to receive read/write queries, with slaves able to 770 accept only read/SELECT queries. The most popular master-slave 771 PostgreSQL replication solution is Slony. There are also commercial 772 and hardware-based replication solutions available. 764 Though “replication” is a single term, there are several technologies 765 for doing replication, with advantages and disadvantages for each. 766 767 Master/slave replication allows a single master to receive read/write 768 queries, while slaves can only accept read/SELECT queries. The most 769 popular freely available master-slave PostgreSQL replication solution
Though “replication” is a single term, there are several technologies for doing replication, with advantages and disadvantages for each. Master/slave replication allows a single master to receive read/write queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I. Multi-master replication allows read/write queries to be sent to multiple replicated computers. This capability also has a severe impact on performance due to the need to synchronize changes between servers. PGCluster is the most popular such solution freely available for PostgreSQL. There are also commercial and hardware-based replication solutions available supporting a variety of replication models.
Though “replication” is a single term, there are several technologies for doing replication, with advantages and disadvantages for each. Our documentation contains a good introduction to this topic at http://www.postgresql.org/docs/8.3/static/high-availability.html and a grid listing replication software and features is at Replication, Clustering, and Connection Pooling Master/slave replication allows a single master to receive read/write queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I. Multi-master replication allows read/write queries to be sent to multiple replicated computers. This capability also has a severe impact on performance due to the need to synchronize changes between servers. PGCluster is the most popular such solution freely available for PostgreSQL. There are also commercial and hardware-based replication solutions available supporting a variety of replication models.
> > > > Though “replication” is a single term, there are two major replication > > technologies. Multi-master replication allows read/write queries to be > > sent to multiple replicated computers. Using this capability has a > > serious performance impact. Pgcluster is the most popular such solution > > available for PostgreSQL. Master-slave replication allows a single > > master to receive read/write queries, with slaves able to accept only > > read/SELECT queries. The most popular master-slave PostgreSQL > > replication solution is Slony. There are also commercial and > > hardware-based replication solutions available. > > A suggestion for rewording: > > Though “replication” is a single term, there are a number of > approaches and technologies to handle it, and thus, for different > purposes, a number of replication systems are available. > > Master/slave replication allows a single master to receive read/write > queries, where slaves can only accept read/SELECT queries. The most > p
