Summary
The pgpool tool is one that has been widely adopted for replication and failover. It offers a vast variety of features including load balancing, connection pooling, and replication. The pgpool tool will replicate data on the statement level and integrate itself with PostgreSQL onboard tools such as streaming replication.
In the next chapter, we will dive into Slony and learn about logical replication. We will discuss the software architecture and see how Slony can be used to replicate data within a large server farm.
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
