On Fri, Nov 1, 2024 at 6:13 PM Torsten Förtsch <tfoertsch...@gmail.com> wrote: > > On Wed, Oct 30, 2024 at 9:01 AM Peter Eisentraut <pe...@eisentraut.org> wrote: >> >> On 27.10.24 13:37, Torsten Förtsch wrote: >> > The attached patch enables pg_recvlogical to create a temporary slot. >> >> I think you should explain a bit why you want to do that, what use case >> or scenario this is meant to address. > > > In my particular case I want to filter for messages sent by > pg_logical_emit_message(). I don't care much about getting ALL the changes. > If the replication slot disappears and a few changes are lost it does not > matter. So, a temporary rep slot makes more sense than creating one and then > having to make sure it is not retaining wal forever later. > > I can imagine this also as a tool to monitor changes for a while and then > simply disconnect without the need to remove the slot. >
Your use case sounds reasonable to me. So, +1 for adding an option for temporary slots. -- With Regards, Amit Kapila.
