Re: Allowing pg_recvlogical to create temporary replication slots

On Fri, Nov 01, 2024 at 01:42:55PM +0100, Torsten Förtsch wrote:
> I was in the process of experimenting with this idea and found that
> pg_recvlogical can:
> - only create the slot or
> - create the slot and immediately use it
> - try to create the slot and if the slot is already there use it
>
> So, why not also allow it to create a temporary slot?

I have no objections. I don't really have an argument regarding the
use cases for specific applications, but I can see myself use this
option for development purposes: I have some experience using
pg_recvlogical for debugging purposes with logical decoding plugins in
the past, requiring always prior replication slot creation.

I can also imagine someone willing to use it on a live server and make
sure that there is no replication slot left behind once the tool has
disconnected on the receiver side.
--
Michael