Use pgpool to achieve query balancing. It can send inserts/updates etc to master and selects to all nodes. Flow: app_server(app+pgpool) -> db_servers(pg_master +pg_slave1+pg_slave2)
Happy to help :) Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com On Tue, Feb 19, 2019 at 2:44 PM soumitra bhandary < soumitra.bhand...@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 >
