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.