On Thu, Dec 24, 2020 at 7:30 PM Jammie <shailesh.jamloki@gmail.com> wrote: > > Sorry dont have the debug setup handy. However the sql commands now works though to move the restart_lsn of the slots in standlone code from psql. > > A few followup questions. > > What is catalog_xmin in the pg_replication_slots ? and how is it playing role in moving the restart_lsn of the slot. > > I am just checking possibility that if a special transaction can cause private slot to stale ? >
Yeah, it is possible if there is some old transaction is active in the system. The restart_lsn is lsn required by the oldesttxn. But it is strange that it affects only one of the slots.
