On 14.04.23 15:22, Drouvot, Bertrand wrote:
Now that the "Minimal logical decoding on standby" patch series (mentioned up-thread) has been committed, I think we can resume working on this one ("Synchronizing slots from primary to standby").
Maybe you have seen this extension that was released a few months ago: https://github.com/EnterpriseDB/pg_failover_slots . This contains the same functionality packaged as an extension. Maybe this can give some ideas about how this should behave and what options to provide etc.
Note that pg_failover_slots doesn't use logical decoding on standby, because that would be too slow in practice. Earlier in this thread we had some discussion about which of the two approaches was preferred. Anyway, that's what's out there.
