Re: physical slot xmin dependency on logical slot?

2019-11-19 Thread Jeremy Finzel
> > I expect that you created the replica in a manner that preserved the > logical replication slot on it. You also had hot_standby_feedback enabled. > As per both you and Andres' replies, we wanted the backup to have the logical slots on it, because we wanted to allow decoding from the slots on

Re: physical slot xmin dependency on logical slot?

2019-11-18 Thread Craig Ringer
On Tue, 19 Nov 2019 at 05:37, Jeremy Finzel wrote: > We had a scenario today that was new to us. We had a logical replication > slot that was severely far behind. Before dropping this logical slot, we > made a physical point-in-time-recovery snapshot of the system with this > logical slot. > >

Re: physical slot xmin dependency on logical slot?

2019-11-18 Thread Andres Freund
Hi, On 2019-11-18 15:36:47 -0600, Jeremy Finzel wrote: > We had a scenario today that was new to us. We had a logical replication > slot that was severely far behind. Before dropping this logical slot, we > made a physical point-in-time-recovery snapshot of the system with this > logical slot.

physical slot xmin dependency on logical slot?

2019-11-18 Thread Jeremy Finzel
We had a scenario today that was new to us. We had a logical replication slot that was severely far behind. Before dropping this logical slot, we made a physical point-in-time-recovery snapshot of the system with this logical slot. This logical slot was causing severe catalog bloat. We