Feedback-ID: i76984098:Fastmail
Message-ID: <65d15f90-9675-4cad-999a-cbd46da7cb38@aklaver.com>
Date: Sat, 8 Nov 2025 08:34:25 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
To: Bala M <krishna.pgdba@gmail.com>
Cc: Greg Sabino Mullane <htamfids@gmail.com>,
 Francisco Olarte <folarte@peoplecall.com>, chris+google@qwirx.com,
 pgsql-general@lists.postgresql.org
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
 <CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com>
 <CAJ4rSwvsRJhwfuem0vsws1WwRZPN8Ju2Nw0e0Oc2j7n=MXUhMg@mail.gmail.com>
 <CAKAnmmK9Fjb5YngH4BSb8Lmk3qh10nw=1M3xdcLatr9-U-f-Ug@mail.gmail.com>
 <CA+bJJbwSZg6fiQ78N-_2NwRBbp=6e5WjnSX9SPa_DOxnaU63Vg@mail.gmail.com>
 <CAJ4rSwstZoVgVjbHeDNVq+7eBWCVZSXjNMRpzB4QFjArZT0Hcg@mail.gmail.com>
 <942b979a-c5e8-40e7-bdec-0234a0e5a010@aklaver.com>
 <CAJ4rSwuMDcsvXNfxBefWfDknoJMkdZoDmOJ_8pmo8ut_h_V57g@mail.gmail.com>
 <b22b949d-0600-47d2-8695-1da83edc2c72@aklaver.com>
 <CAJ4rSwvRHM=oKb_Ri-PpK=4fS_ciZFCoMSgF1P=OdJv2aU5XJg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJ4rSwvRHM=oKb_Ri-PpK=4fS_ciZFCoMSgF1P=OdJv2aU5XJg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/65d15f90-9675-4cad-999a-cbd46da7cb38%40aklaver.com>
Precedence: bulk

On 11/6/25 16:30, Bala M wrote:
> *
> *
> *1) Show how you have set up the publishers and subscribers.*
> 
> We have configured logical replication between PostgreSQL 11 (publisher) 
> and PostgreSQL 16 (subscriber).
> 
> Publisher: PostgreSQL 11 with wal_level=logical, 
> max_replication_slots=20, and publication created for all tables (FOR 
> ALL TABLES).
> 

I have not worked with a database of this size, still I would think FOR
ALL TABLES is not the way to go. That it along with the existing 
activity on the publisher would result in a slow transfer of data.

-- 
Adrian Klaver
adrian.klaver@aklaver.com