Re: Logical replication issue after Postgresql upgrade from 13 to 14

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Sergey Belyashov <sergey(dot)belyashov(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication issue after Postgresql upgrade from 13 to 14
Date: 2021-12-01 12:26:16
Message-ID: CAB-JLwZH-cxJjZs_VvQa3+61cw++bkWpg4Judn+Qo1PTHnRJqA@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?
>

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Belyashov 2021-12-01 12:30:55 Re: Logical replication issue after Postgresql upgrade from 13 to 14
Previous Message Tom Lane 2021-12-01 12:12:57 Re: Issues cross-compiling libpq 14.x to MacOS armv8