On 6/28/18 08:47, Michael Paquier wrote: >>> There could be some cases where >>> copying a physical slot also makes sense. >> I've thought that but I didn't find concrete use case. That's why I >> started with only logical slot. > Let's imagine the case of a single base backup which is associated to a > given replication slot, and that this backup is then used to spawn > multiple standbys where each one of them needs a separate slot to > consume changes at their pace. If you can copy the slot used in the > first backup, then both nodes could consume it. That looks useful to > me to make sure that both slots are based a consistent point.
I think this use case of cloning replicas would also be interesting in the logical slot case. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
