public inbox for [email protected]  

help / color / mirror / Atom feed

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

Hi Peter,

We are using streaming replications but still reindex is not working source
db has 11.15replica has 11.11 PostgreSQL version.

Regards,
Mohammed Afsar


On Fri, 16 Aug 2024 at 6:33 PM, Peter Gram <[email protected]> wrote:

> 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: <CA+6HduuHBaHju0xkuBUkOz5dYkkrotgyGTdt1dj75Et1NECeoQ@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