Re: Load balancing in postgres master slave HA cluster

Hi Sumitra,

You can achieve this by using the pgpool which support load balancing/load
connections and allow huge insert/updates. Either you can divert your read
queries to slave for read and write to master for read/write operations

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Tue, Feb 19, 2019 at 2:44 PM soumitra bhandary <
soumitra(dot)bhandary(at)hotmail(dot)com> wrote:

> 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 . Please share me the steps .
>
> Or ,
>
> Any other method can be used to achieve the same using freeware .
>
> Thanks
> Soumitra
>