Re: Reindex doesn’t not working replica nodes

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Peter Gram <[email protected]>
To: khan Affan <[email protected]>
Cc: Mohammed Afsar <[email protected]>
Cc: [email protected]
Cc: pgsql-admin <[email protected]>
Subject: Re: Reindex doesn’t not working replica nodes
Date: Fri, 16 Aug 2024 15:03:01 +0200
Message-ID: <CAJ=80GUOozWnm14_vJ3MccTZ9LNJ7d6Rsd_bkszMr=MrWdFm-w@mail.gmail.com> (raw)
In-Reply-To: <CAF4emOmk7ZOqQ0+0FDzaPY+ZkisMYVa4QAhC8MjdQdr2MQViTA@mail.gmail.com>
References: <CA+6HdutGU9Au=ADaa+Q6jp=HGXFeUrtBPcfdHKK2fLdeKnd+Tg@mail.gmail.com>
	<CAF4emOmk7ZOqQ0+0FDzaPY+ZkisMYVa4QAhC8MjdQdr2MQViTA@mail.gmail.com>

Hi Mohammed

If we are talking physical replication then the wall includes changes to
index’s data. If we are talking logical replication the wall does not
include index changes.

Med venlig hilsen

Peter Gram
Sæbyholmsvej 18
2500 Valby

Mobile: (+45) 5374 7107
Email: [email protected]



On Fri, 16 Aug 2024 at 13.20, khan Affan <[email protected]> wrote:

> Hi Mohammed,
>
> PostgreSQL replication is based on replicating WAL (Write-Ahead Log)
> records, which capture changes to data files such as inserts, updates,
> deletes, and the creation of new tables. However,
>
> WAL does not include the physical structure of indexes.
>
> If you're encountering issues like zero rows being fetched from the
> replica, it could be due to index inconsistencies or replication lag. To
> ensure your read replica has updated indexes, you can promote the replica
> to be the primary node, perform the REINDEX operation, and then revert the
> roles, making the original primary node the primary again.
>
> Regards
> Muhammad Affan
>
> On Wed, Aug 14, 2024 at 5:58 PM Mohammed Afsar <[email protected]> wrote:
>
>> Dear experts,
>>
>>
>> We have initiated reindex on source db but it not replicated to replica
>> db and we have having select query fetching with zero rows but data exiting
>> on the table.
>> Postgres 11.10 streaming replication
>>
>> Regards,
>> Mohammed Afsar
>>
>

view thread (8+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Reindex doesn’t not working replica nodes
  In-Reply-To: <CAJ=80GUOozWnm14_vJ3MccTZ9LNJ7d6Rsd_bkszMr=MrWdFm-w@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox