Re: Copy function for logical replication slots - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Copy function for logical replication slots
Date
Msg-id 73bbc1ee-314f-85ab-2c25-f1670101d84d@2ndquadrant.com
Whole thread Raw
In response to Re: Copy function for logical replication slots  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Copy function for logical replication slots
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ALTER TABLE on system catalogs
Next
From: Peter Eisentraut
Date:
Subject: Re: partition tree inspection functions