Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What replication solutions are available?

April 26, 2017replication solutions

0

10 Posted

What replication solutions are available?

6 Answers

« Previous 1 2

0

Posted

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.

« Previous 1 2