From: | Peter Gram <peter(dot)m(dot)gram(at)gmail(dot)com> |
---|---|
To: | Loles <lolesft(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: The logical replica crashes when a failover occurs in the physical replica |
Date: | 2023-04-05 11:59:53 |
Message-ID: | CAJ=80GUcHt9f4c9R-zWxiCj+QBdc1YEb==b-99SJvgFY74EDvA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Loles
The problem is that the replication slots for logical replication on the
primary are not replicated to the standby server.
EDB is working on a general fix to postgres version 16 or 17.
I think patroni har work around you can look on.
Best regards/Venlig hilsen
Peter Gram
Sæbyholmsvej 18 DK-2500 Valby
Mobile: (+45) 5374 7107
Email: peter(dot)m(dot)gram(at)gmail(dot)com
On Wed, 5 Apr 2023 at 13:18, Loles <lolesft(at)gmail(dot)com> wrote:
> Hi Community,
>
> I have a problem related to native PostgreSQL logical replication.
>
> I have three servers, two of them (node1 and node2) are configured in
> physical replica working correctly. The failover happens between them also
> without problems.
>
> Between them there is a floating virtual IP that always is up on the
> server that has the role of Primary.
>
> The Primary server has been configured as a Publisher and a third server
> (node3) has been configured as a Subscriber for a cluster database by
> connecting to the virtual IP.
>
> The objective is that the Subscriber server receives the data from the
> Primary server, either (node1 or node2) one is.
>
> But it does not work. When the failover occurs, the Standby server
> promotes as Primary, acquires the Virtual IP but the Subscriber stops
> replicating.
>
> The following lines are recorded in the subscriber log:
>
> 2023-04-05 13:16:10.575 CEST [7154] LOG: el ayudante «apply» de
> replicación lógica para la suscripción «db_demo_sub» ha iniciado
>
> 2023-04-05 13:16:10.590 CEST [7154] ERROR: no se pudo iniciar el flujo de
> WAL: ERROR: no existe el slot de replicación «db_demo_sub»
>
> 2023-04-05 13:16:10.592 CEST [6694] LOG: proceso ayudante «logical
> replication worker» (PID 7154) terminó con código de salida 1
>
> Any ideas?
>
> We want the Subscriber always replicate the data from the Primary server,
> whatever it is. That's why the virtual IP, but it's not working.
>
> Thanks!
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Loles | 2023-04-05 15:25:23 | Re: The logical replica crashes when a failover occurs in the physical replica |
Previous Message | Loles | 2023-04-05 11:17:44 | The logical replica crashes when a failover occurs in the physical replica |