| 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.
| 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 |