On Tue, Apr 10, 2018 at 11:04 AM, Vikas Sharma <shavikas@xxxxxxxxx> 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.RegardsVikasOn 10 April 2018 at 15:26, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
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_%';
--
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!
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!
