Horton
Menu

Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)

Adrian Klaver <adrian.klaver@aklaver.com>

View thread
From: Adrian Klaver <adrian.klaver@aklaver.com>
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
Date: 2025-11-08T16:34:25Z
Lists: pgsql-general 
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