Re: Logical replication issue after Postgresql upgrade from 13 to 14 - Mailing list pgsql-general

From Amit Kapila
Subject Re: Logical replication issue after Postgresql upgrade from 13 to 14
Date
Msg-id CAA4eK1KeUF535+r_Z3oF14bXaGfRvSDZFptDp=SUQ18PZchXZg@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication issue after Postgresql upgrade from 13 to 14  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-general
On Wed, Dec 1, 2021 at 5:56 PM Marcos Pegoraro <marcos@f10.com.br> wrote:
>
>> I have an issue with logical replication after Postgresql upgrade from
>> 13 to 14 (upgraded subscriber only using pg_upgrade_cluster -m link 13
>> main). After upgrade all subscriptions were disabled so I have enabled
>> them and replication workers successfully started.
>> pg_stat_subscription contains list of all subscriptions. All times in
>> this table is near current time (replication workers receives data
>> from servers). But no changes in destination table since cluster
>> upgrade (on publishers tables are changed). What I'm doing wrong and
>> how to fix issue?
>
>
> Amit, wouldn't it be better to document all steps needed to use pg_upgrade with logical replication ?
> Sergey is showing a different problem than mine.
>

I am fine with that. Feel free to propose a patch on -hackers. I can
help in reviewing and improving the same.

-- 
With Regards,
Amit Kapila.



pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Linux: directory change .../lib to .../lib64
Next
From: Tom Lane
Date:
Subject: Re: Linux: directory change .../lib to .../lib64