pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: [External] Re: WAL Replication query
Date: Wed, 2 Nov 2022 00:54:06 -0500
Message-ID: <54ba769f-7361-5df9-75fa-43669faf701e@gmail.com> (raw)
In-Reply-To: <CAKgGyB-faJD0QyOS8sLDuU7H9f+bWtE0phh1WE0Dhn5z-xvn3A@mail.gmail.com>
References: <CAKgGyB-SMT0RxeoifAfjkRx6RHEOgpn7sf8F_zD1DPsKydTu=w@mail.gmail.com>
	<88faef33e966796226022d6e7f3e32ad6c59fcfd.camel@cybertec.at>
	<MW4PR20MB4525ED0222DDE9FED0519D8FF3369@MW4PR20MB4525.namprd20.prod.outlook.com>
	<c1b6b89d6b89706acaeca9b4d45958f4739c4f28.camel@cybertec.at>
	<8f9e6c92-4daa-a543-6825-05a3503f4296@gmail.com>
	<f78c361061449be8402922cd5ed7f5782f65aab1.camel@cybertec.at>
	<42306ea2-74c2-a95e-551d-e1d16946c083@gmail.com>
	<cff94aa50765b00e798d15a5419830c82f8049ec.camel@cybertec.at>
	<CAKgGyB-faJD0QyOS8sLDuU7H9f+bWtE0phh1WE0Dhn5z-xvn3A@mail.gmail.com>

On 11/1/22 23:00, KK CHN wrote:
[snip]
> So there will be an inconsistency in the data  between the current  
> Primary  ( promoted standby)  and my recovered /repaired old server ( 
> which was primary before the crash).
>
>    How to handle this data inconsistency or what best mechanism needs to 
> be implemented if you were me in this use case scenario?

Before promoting Secondary to New Primary, I'd record it's current 
pg_stat_replication.replay_lsn value somewhere and then compare it to the 
relevant LSN on Old Primary when it comes back up.

If they're the same, then there's no data inconsistency.

If there is, then you've got to manually check tables, since every 
application and database structure is different

-- 
Angular momentum makes the world go 'round.

view thread (15+ messages)  latest in thread

Message-ID: <54ba769f-7361-5df9-75fa-43669faf701e@gmail.com>
Permalink:  ../54ba769f-7361-5df9-75fa-43669faf701e@gmail.com/
Also on:    postgresql.org/message-id/54ba769f-7361-5df9-75fa-43669faf701e@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: [External] Re: WAL Replication query
  In-Reply-To: <54ba769f-7361-5df9-75fa-43669faf701e@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox