Re: Postgresql Split Brain: Which one is latest - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Postgresql Split Brain: Which one is latest
Date
Msg-id 986dc1fd-67e3-7992-8941-d9964e9f3220@aklaver.com
Whole thread Raw
In response to Re: Postgresql Split Brain: Which one is latest  (Vikas Sharma <shavikas@gmail.com>)
List pgsql-general
On 04/10/2018 10:02 AM, Vikas Sharma wrote:
> Max count is one way (vague I agree), before confirming I will ask the 
> application owner to have a look on data in tables as well.

Along that line and dependent on the size of the database and individual 
tables you might try:

1) Do a plain text dump of the data from the same table from each master.

2) Diff the data dumps.

> 
> Regards
> 
> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Vikas Sharma
Date:
Subject: Re: Postgresql Split Brain: Which one is latest
Next
From: Raghavendra Rao J S V
Date:
Subject: Suggest the best values for the postgres configuration parameters