I think there are some bugs in Posgresql logical replication upgrade.
Because dropping and recreating subscriptions with manual
synchronization has solved the problem for me. But it is not the
correct way, IMHO.
Sergey Belyashov
ср, 1 дек. 2021 г. в 15:26, Marcos Pegoraro <marcos@f10.com.br>:
>
>
>> 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.