Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1seDZz-0052Dr-8v
	for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2024 12:58:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1seDZx-00AGI7-Ho
	for pgsql-admin@arkaria.postgresql.org; Wed, 14 Aug 2024 12:58:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <vmdapsar@gmail.com>)
	id 1seDZx-00AGHz-5y
	for pgsql-admin@lists.postgresql.org; Wed, 14 Aug 2024 12:58:17 +0000
Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <vmdapsar@gmail.com>)
	id 1seDZv-004olx-29
	for pgsql-admin@postgresql.org; Wed, 14 Aug 2024 12:58:16 +0000
Received: by mail-oa1-x31.google.com with SMTP id
 586e51a60fabf-2681941eae0so3975621fac.0
        for <pgsql-admin@postgresql.org>;
 Wed, 14 Aug 2024 05:58:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1723640293; x=1724245093;
 darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=FFkTlgg9yKvScv8sVQ6XQqipoaChXj5wGBEqWrI2lcU=;
        b=VKOKrrxdGRXUaQ0ybeKtvyXO/AJtd4RgJl3WO0eDzG0sWxwdDV73OcFz13nThvBz7h
         KAkfC0dL5eLMGXklN98oU4EwbdeN1uk4N8yXi+MPR/Z1aD7UyLZiiXLKEHJ9N80GVz6W
         V48JrkhOjRj1qU+IJ1ZqDAX9/xAcJg/3faQmHzmlZrrps+da2mD85sTpif13Z+icZdw6
         xExKNVhUzE4cBZ9xNwAQbz4RLkRcV6zgQuUi5LFk/5mrMc9a9B3gAQld2H3X+inZqWVC
         84cebMLjL8Ykouy2ZEhyFq7WndBbsFw5Z0imOTQdbbP/TlUkXoYVYttnDO+37244FKL/
         c0fA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1723640293; x=1724245093;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=FFkTlgg9yKvScv8sVQ6XQqipoaChXj5wGBEqWrI2lcU=;
        b=ENXn9LWMMGRvOdDa6L8UM14VFFnYcsBSkNbgcS4leXAPUqXwZqANWijBUdT2krAogQ
         zhpCxYQyiJ3yKCU9nvR7nME8f+H7IQUaU6faGj0GUSjMmydorOGoclfrq2uxOU3ITOMB
         4lm4YtwNV04Zme/EmXJlWGYWXBuaf96oFFxp8MM0eGb6ulHPaSOfZTsA55g0Y2ZW2Yj2
         +p/A+xKU2nFN3Q1Gj6VuUVciv/V8dvS3Dmk32qibCHLpJANfLdJDHwWgMUdAE298zoAr
         ya2OtgbbLL8W5AU3uMZ1oG6BXONXoQLtpVIqvOJYH98BQz4s4AaClguBM9K+Ls9DqpRT
         Z+Gg==
X-Forwarded-Encrypted: i=1;
 AJvYcCW55syEmRoluhNgk2foRgQw5dtiRrqugVZKkM+TfiLvE3/On+4xU9lciGGTx+TaxdAFvKRt5kbcZgT+qqyHQwTOQeWrW4QS0XHSXw==
X-Gm-Message-State: AOJu0Yzv9DuugWSMi9zg6h6M7HdQMF3PKO5FGFwEv9UdoBaJRrv7ZDwH
	nxlo+nWuOPET9cB6I4nYbFGp6rpNoWlT3ZERpUFW8u3TjZqJWID7Tv1ehfZ889uVr1Gc1rZ+ulz
	gac35h5S/AMkdVizSDRBWbMk0bSE=
X-Google-Smtp-Source: 
 AGHT+IF4dSYdE8Qde6b7JenKJC6zk/wlGbtTWI61GovH1EWpUH6n+mCMIZ7xiFmX5L0AySrn84JbbA3d8h5SFdl4FTE=
X-Received: by 2002:a05:6870:7994:b0:261:e19:458d with SMTP id
 586e51a60fabf-26fe59c70aamr3091756fac.4.1723640292937; Wed, 14 Aug 2024
 05:58:12 -0700 (PDT)
MIME-Version: 1.0
From: Mohammed Afsar <vmdapsar@gmail.com>
Date: Wed, 14 Aug 2024 18:28:01 +0530
Message-ID: 
 <CA+6HdutGU9Au=ADaa+Q6jp=HGXFeUrtBPcfdHKK2fLdeKnd+Tg@mail.gmail.com>
Subject: =?UTF-8?Q?Reindex_doesn=E2=80=99t_not_working_replica_nodes?=
To: pgsql-admin@lists.postgresql.org, pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000619921061fa4474e"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B6HdutGU9Au%3DADaa%2BQ6jp%3DHGXFeUrtBPcfdHKK2fLdeKnd%2BTg%40mail.gmail.com>
Precedence: bulk

--000000000000619921061fa4474e
Content-Type: text/plain; charset="UTF-8"

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

--000000000000619921061fa4474e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Dear experts,</div><div dir=3D"auto"><br></div><div dir=
=3D"auto"><br></div><div dir=3D"auto">We have initiated reindex on source d=
b but it not replicated to replica db and we have having select query fetch=
ing with zero rows but data exiting on the table.<br clear=3D"all">Postgres=
 11.10 streaming replication=C2=A0<br clear=3D"all"><div dir=3D"auto"><div =
dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><d=
iv dir=3D"ltr"><br></div><div dir=3D"ltr">Regards,</div><div dir=3D"ltr">Mo=
hammed Afsar</div></div></div></div>

--000000000000619921061fa4474e--