pgpool-II is not following new master node post master fail over

2019-06-05 Thread soumitra bhandary
Hi , I am using repmgr to manage the auto fail over process at PostgreSQL Database layer in a 3 node master - slave replication . Also using pgpool-II to manage the load balancing and application connection routing. But when any master failover is happening at DB side and new master is promote

Load balancing in postgres master slave HA cluster

2019-02-19 Thread soumitra bhandary
Hi , Any one has experience on working with HA proxy set up with Postgres Master Slave replication . Query : I would like to divert the Write requests to Master and all read requests to Slave server . To achieve that can I use HA proxy server ? If any one has already implemented the same .