Em 10/04/2018 12:28, Melvin Davidson escreveu:
On Tue, Apr 10, 2018 at 11:04 AM, Vikas Sharma <shavikas@xxxxxxxxx
<mailto: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.
Regards
Vikas
On 10 April 2018 at 15:26, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto: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 <mailto: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_%';*
--
*Melvin Davidson**
Maj. Database & Exploration Specialist**
Universe Exploration Command – UXC*
Employment by invitation only!
I'm just trying to understand the scenario...
Correct me if I'm wrong, if you had two servers acting as master for a
while, then you have inserted/updated records on both servers, and you
will need some kind of "merge" of records into one of the databases,
that will become the new updated master...
If you have "sequences" (or "serial" fields), then you will get a bit
trouble in your hands.
Regards,
Edson
