Re: Postgresql Split Brain: Which one is latest

Hi Adrian,

This can be a good example: Application server e.g. tomcat having two
entries to connect to databases, one for master and 2nd for Slave (ideally
used when slave becomes master). If application is not able to connect to
first, it will try to connect to 2nd.

Regards
Vikas

On 10 April 2018 at 15:26, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 04/10/2018 06:50 AM, Vikas Sharma wrote:
>
>> Hi,
>>
>> We have postgresql 9.5 with streaming replication(Master-slave) and
>> automatic failover. Due to network glitch we are in master-master situation
>> for quite some time. Please, could you advise best way to confirm which
>> node is latest in terms of updates to the postgres databases.
>>
>
> It might help to know how the two masters received data when they where
> operating independently.
>
>
>> Regards
>> Vikas Sharma
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>