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 .

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