create change request to change pgbouncer from separeted nodes to the master database host
due to the saturation issues, we have seen last days, I suggest to add 3 pgbouncer nodes on the primary database. With this change, we will remove the intermediate layer of pgbouncers and change from 2 to 3 nodes. We would stop using the ILB and redirect our application to use the pgbouncers, as we use in the secondary's databases.
We need to rebalance the number of connections from the pgbouncer pools to do not exceed the database limit. Please test in staging first.