Re: Postgresql Split Brain: Which one is latest

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Vikas Sharma <shavikas(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql Split Brain: Which one is latest
Date: 2018-04-10 17:07:19
Message-ID: 986dc1fd-67e3-7992-8941-d9964e9f3220@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-04-10 17:32:50 Suggest the best values for the postgres configuration parameters
Previous Message Vikas Sharma 2018-04-10 17:02:39 Re: Postgresql Split Brain: Which one is latest