Re: Configuration of django with master slave replication Postgres

PgPool-II is very much suitable for your case. It will distribute your read
queries on master and slaves + automatic master switch detection +
connection pools.

Happy to help :)
Prince Pathria Systems Engineer Evive +91 9478670472 goevive.com

On Tue, Apr 2, 2019 at 5:52 PM Thomas Poty <thomas(dot)poty(at)gmail(dot)com> wrote:

> As you are using pg 9.5, these links may help :
>
>
> https://severalnines.com/blog/postgresql-load-balancing-using-haproxy-keepalived
> https://clusterlabs.github.io/PAF/
>
> Le mar. 2 avr. 2019 à 13:50, soumitra bhandary <
> soumitra(dot)bhandary(at)hotmail(dot)com> a écrit :
>
>>
>> Hi
>> Does anyone have any idea with django how to configure multiple dsn that
>> will automatically switch to new Postgres master host in case of failover
>> happens to previous master and auto promotion of new master is done with
>> repmgr.
>>
>>
>> My configuration is as below
>>
>> Master and asynchronous slave node . Repmgrd is configured to take care
>> of autofailover and promotion of new master node.
>>
>> But from application side with django how to make datasource so that it
>> automatically switches to new master node in case of failover.
>> Please share the steps.
>>
>>
>> Sent from my iPhone
>>
>>