Logical replication issue after Postgresql upgrade from 13 to 14

From: Sergey Belyashov <sergey(dot)belyashov(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical replication issue after Postgresql upgrade from 13 to 14
Date: 2021-11-30 11:16:32
Message-ID: CAOe0RDwdDr1b7e58J7ZiYkxNZqYSYn0DTS-CGE2Stt3nXUSXMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Sergey Belyashov

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yi Sun 2021-11-30 13:53:06 ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
Previous Message Saurav Sarkar 2021-11-30 06:13:43 Database Scalability