On Tue, Apr 10, 2018 at 11:04 AM, Vikas Sharma <shavi...@gmail.com> wrote:
> 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.kla...@aklaver.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.kla...@aklaver.com >> > > *Vikas,* *Presuming the the real "master" will have additional records/rows inserted in the tables,* *if you run ANALYZE on the database(s) in both "masters", then execute the following query * *on both, whichever returns the highest count would be the real "master". SELECT sum(c.reltuples::bigint) FROM pg_stat_all_tables s JOIN pg_class c ON c.oid = s.relid WHERE s.relname NOT LIKE 'pg_%' AND s.relname NOT LIKE 'sql_%';* -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!