On 4/11/17 05:15, Magnus Hagander wrote: > 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?
I suppose there could be lots of problems if the LSN you specify isn't valid. And it might be hard to determine whether a given LSN is valid. If this could be made to work, this would actually offer an interesting option for dumping and restoring subscriptions. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers