Re: how to perform a manual failover with patroni without applying any outstanding WAL?
| От | Muhammad Imtiaz |
|---|---|
| Тема | Re: how to perform a manual failover with patroni without applying any outstanding WAL? |
| Дата | |
| Msg-id | CANwR1ORhME6_T1KkQTQAHFZtDB-g+ZhYJcETCSYtr5Ku9wq_=g@mail.gmail.com обсуждение исходный текст |
| Ответ на | how to perform a manual failover with patroni without applying any outstanding WAL? ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>) |
| Список | pgsql-admin |
You can follow these guidelines, and they should be helpful for you.
- Stop the patroni on Primary Node
- Stop the patroni on Standby Node and promote the standby as primary
pg_ctl promote -D "Path to Data Directory" - Set the primary role in the Patroni configuration file on the new primary and restart the patroni .
Regards,
Muhammad Imtiaz
We have a simple Patroni config (1 primary + 1 standby).
We configured the standby to run 3 hours behind the primary:
+ recovery_min_apply_delay: '3h' # standby 3 hours behind
+ synchronous_mode: false # asynchron
In case there is a logical problem on the primary (wrong data processing, misleaded application upgrade,…) we want to perform a manual failover to the standby, which still contains the old, correct data status.
That means the standby should __not__ apply any more WALs within the 3 hour residue in the event of a manual failover.
When I tried a "patronictl failover" the standby first applied all outstanding WALs (which I don't want) and only then promoted the standby.
Any idea?
В списке pgsql-admin по дате отправления: