hapostgres / hapostgres/pg_auto_failover

Feature request post failover command

Open
#878 6 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
142
Avg merge
5h 8m
Merged PRs (30d)
1

Description

Salut Dimitri,

Aim is to provide a parameter to execute a command (whatever command DBAs set) once a failover successfully happened

Use case is:
- sometimes after a failover we have to switch some settings (example switching Barman passive repository to active repository)
- another example is indirection (a.k.a switch-ip) if client does not support native high availability (e.g. they can't set two hosts on connection strings, example ODBC or embedded drivers configuration ), we could use this parameter (for example to reconfigure pgbouncer)

Because the only component which knows that a failover completely and succefullly happened is pg_autofailover.

- This command should be decorralated, if an error happens it simply should be list in the pg_autoctl log file.
- Most HA tools know provide this add-hoc parameter
Merci

Tiago

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.