[question] Plans to support delayed replica?

[s4ke]

Hey,

something that came up in our discussions is whether pg_auto_failover could handle configuration of delayed replicas.

With the current version it should be possible to achieve this by using an async standby with something like wal-e to do the log shipping, but we were wondering if this is somewhere on the roadmap for pg_auto_failover.

[DimCitus]

Hi @s4ke ; thanks for asking. Yes that's on the roadmap, see https://github.com/citusdata/pg_auto_failover/pull/596. This is the beginning of the work, more ideas are there to explore around the concepts. Meanwhile you can have a standby node that is not a candidate for failover, and async (--candidate-priority 0 --replication-quorum false) and then edit its setup to add https://postgresqlco.nf/doc/en/param/recovery_min_apply_delay/