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 failover.
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 current").
--