Is there a particular reason we don't have a function to *set* the
restart_lsn of a replication slot, other than to drop it and recreate it?

Similarly, to create one with a fixed value for restart_lsn and not
necessarily the one the machine is at right now?

Basically I'm doing a small script that keeps a replication slot on the
standby reasonably in sync with the master, for use in the case of a

AFAICT the only way to do it now is to either connect with the replication
protocol and actually consume the data (which seems quite wasteful), or to
drop and recreate the slot (in which case we can't actually determine the
location it gets set to keep, because it will be set to "whatever is

 Magnus Hagander
 Me: <>
 Work: <>

Reply via email to