Load Balancing PostgreSQL Cluster with Repmgr and Pg-Pool-II

In the previous post, I have demonstrate how to create PostgreSQL-12 replication server. I will work well for distribute the connection to both master and slave. But problem is when you create a resource to connect to both databases you need to create two data sources separately which is not realistic the practical application. You need to access to single point of the resource and your connection will be distributed automatically. You don't need to manage connection to the datasource manually. Postgresql provides the solution for this problem by Pg-Pool-II which you have multiple databases (master / slave). You can access to the datasource from one single point of access. Pg-Pool will handle distribution of the connection automatically. So, in this post I will show you how to use Pg-Pool-II to handle request to your database cluster automatically. Read more