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:
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:
When pgpool is started, we fire up the pgpool parent process. This process will fork and create the so-called child processes. These processes will be in charge of serving requests to end users and handle all the interaction with our database nodes. Each child process will handle a couple of pool connections. This strategy will reduce the number of authentication requests to PostgreSQL dramatically.
In addition to that we have the PCP infrastructure needed to handle configuration and management. We will discuss this infrastructure...
