Understanding the pgpool architecture

Once we have installed pgpool, it is time to discuss the software architecture. From a user's point of view, pgpool looks just like a normal database server, and you can connect to it like to any other server as shown in the following image:

Understanding the pgpool architecture

The pgpool tool will dispatch requests according to your needs.

Once you have understood the overall architecture as it is from a user's point of view, we can dig into a more detailed description:

Understanding the pgpool architecture

When pgpool is started, we fire up the pgpool parent process. This process will ...

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.