Explore PG extension for setting up replication streams in the past

Learned at FOSDEM this weekend about this PG extension: https://github.com/x4m/pg_tm_aux

It looks like this would address the issue of resuming logical replication from a secondary promoted to primary after a fail-over, as one could create a new slot on the now primary and set it to the last committed offset.

Related resources (see this conversation for more interesting details):

• Thorough explanation of how change events can get lost upon fail-over (see links in that issue for more insights)
• Pending PR for adding fail-over slots to Patroni