Postgres Pro
Downloads
Home   >   mailing lists

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

From soumitra bhandary
Subject Load balancing in postgres master slave HA cluster
Date
Msg-id PN1PR0101MB210960505AC86C0E5C6A2607E07C0@PN1PR0101MB2109.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Load balancing in postgres master slave HA cluster  (Prince Pathria <prince.pathria@goevive.com>)
Re: Load balancing in postgres master slave HA cluster  (Prince Pathria <prince.pathria@goevive.com>)
Re: Load balancing in postgres master slave HA cluster  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: Load balancing in postgres master slave HA cluster  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: Load balancing in postgres master slave HA cluster  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-admin
Tree view
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: Steven Crandell
Date:
Subject: Re: Make grant all on all tables in schema x persistent for new tables
Next
From: Prince Pathria
Date:
Subject: Re: Load balancing in postgres master slave HA cluster