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
On Tue, Feb 19, 2019 at 2:44 PM soumitra bhandary <soumitra.bhandary@xxxxxxxxxxx> 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 .
ThanksSoumitra
