Postgres Pro
Downloads
Home   >   mailing lists

Re: Load balancing in postgres master slave HA cluster - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Load balancing in postgres master slave HA cluster
Date
Msg-id CAGDYbUOs1csENf+TeNq9fm8RynS6qq=cBOdL7EYVxB7uxw_c2Q@mail.gmail.com
Whole thread Raw
In response to Load balancing in postgres master slave HA cluster  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
List pgsql-admin
Tree view
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.bhandary@hotmail.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 

pgsql-admin by date:

Previous
From: Prince Pathria
Date:
Subject: Re: Load balancing in postgres master slave HA cluster
Next
From: Achilleas Mantzios
Date:
Subject: Re: Load balancing in postgres master slave HA cluster