In the previous chapter, we looked at PgBouncer and learned how to use it to optimize replicated setups as much as possible. In this chapter, we will take a look at a tool called pgpool. The idea behind pgpool is to bundle connection pooling with some additional functionality to improve replication, load balancing, and so on. It has steadily been developed over the years and can be downloaded freely from the www.pgpool.net website.
PostgreSQL Replication, Second Edition
PostgreSQL Replication, Second Edition
Overview of this book
Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Understanding the Concepts of Replication
Understanding the PostgreSQL Transaction Log
Understanding Point-in-time Recovery
Setting Up Asynchronous Replication
Setting Up Synchronous Replication
Monitoring Your Setup
Understanding Linux High Availability
Working with PgBouncer
Working with pgpool
Configuring Slony
Using SkyTools
Working with Postgres-XC
Scaling with PL/Proxy
Scaling with BDR
Working with Walbouncer
Index
Customer Reviews