| From: | Alexander Kukushkin <cyberdemn(at)gmail(dot)com> |
|---|---|
| To: | Fabrice Chapuis <fabrice636861(at)gmail(dot)com> |
| Cc: | shveta malik <shveta(dot)malik(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Subject: | Re: Issue with logical replication slot during switchover |
| Date: | 2025-11-04 13:01:45 |
| Message-ID: | CAFh8B=nM8mHpSPhVb5aGLf9nAeGWCci2Nn=QEV1+QLtUp1rX7g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 4 Nov 2025 at 12:15, Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
wrote:
> Hi Alexander,
> I understand your use case but I think it won't work like this because of
> how is implemented get_local_synced_slots()
> this function will return slots which synced flag to true only.
>
Yeah. Sorry, my bad, you are absolutely right
about get_local_synced_slots() function.
I didn't validate this part of the patch, because first I wanted to get
feedback from hackers.
However, it looks like the people who build it never run Postgres in
production and therefore don't understand the problem and the pain.
I will probably just add yet another workaround to Patroni and start
dropping logical replication slots on standby with failover=true and
synced=false.
--
Regards,
--
Alexander Kukushkin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ranier Vilela | 2025-11-04 13:17:17 | Re: Enhance security permissions |
| Previous Message | Jonathan Gonzalez V. | 2025-11-04 13:00:55 | Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode |