Re: AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
"Zwettler Markus (OIZ)" wrote on 2019/11/08
11:54:14 AM:
> > (please don't top post, makes the replies hard to follow)
>
> > patronictl switchover
>
> > follow the prompts
>
> > there is also a /switchover API endpoint you can use.
>
> > Brad
>
> I wondered about your "patronictl switchover + systemd" hint. How
> would you do ("gate") this combination?
Change whatever process you are using today to shut things down to call the
patroni switchover first, check error codes, etc.
AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
? "Zwettler Markus (OIZ)"
mailto:markus.zwett...@zuerich.ch>> wrote on
2019/11/08 11:27:00 AM:
>> From: "Zwettler Markus (OIZ)"
>> mailto:markus.zwett...@zuerich.ch>>
>> To: Brad Nicholson mailto:br...@ca.ibm.com>>
>> Cc: Adrian Klaver
>> mailto:adrian.kla...@aklaver.com>>, "pgsql-
>> gene...@lists.postgresql.org<mailto:gene...@lists.postgresql.org>"
>> mailto:pgsql-general@lists.postgresql.org>>
>> Date: 2019/11/08 11:27 AM
>>> Subject: [EXTERNAL] AW: AW: AW: AW: AW: AW: broken backup trail
>> in case of quickly patroni switchback and forth
>>
>> How exactly? Please clarify.
> (please don't top post, makes the replies hard to follow)
> patronictl switchover
> follow the prompts
> there is also a /switchover API endpoint you can use.
> Brad
I wondered about your "patronictl switchover + systemd" hint. How would you do
("gate") this combination?
Markus
Re: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
"Zwettler Markus (OIZ)" wrote on 2019/11/08 11:27:00 AM: > From: "Zwettler Markus (OIZ)" > To: Brad Nicholson > Cc: Adrian Klaver , "pgsql- > gene...@lists.postgresql.org" > Date: 2019/11/08 11:27 AM > Subject: [EXTERNAL] AW: AW: AW: AW: AW: AW: broken backup trail > in case of quickly patroni switchback and forth > > How exactly? Please clarify. (please don't top post, makes the replies hard to follow) patronictl switchover follow the prompts there is also a /switchover API endpoint you can use. Brad
AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
How exactly? Please clarify. "Zwettler Markus (OIZ)" mailto:markus.zwett...@zuerich.ch>> wrote on 2019/11/08 11:02:49 AM: > From: "Zwettler Markus (OIZ)" > mailto:markus.zwett...@zuerich.ch>> > To: Brad Nicholson mailto:br...@ca.ibm.com>> > Cc: Adrian Klaver > mailto:adrian.kla...@aklaver.com>>, "pgsql- > gene...@lists.postgresql.org<mailto:gene...@lists.postgresql.org>" > mailto:pgsql-general@lists.postgresql.org>> > Date: 2019/11/08 11:02 AM > Subject: [EXTERNAL] AW: AW: AW: AW: AW: broken backup trail in > case of quickly patroni switchback and forth > > Let me clarify: "But, it might start killing processes after a > certain period if a _fast_ shutdown after SIGTERM didn't happen". > > I am talking about stopping the Patroni master process with a systemd scipt. Use the switchover functionality in Patroni first, and gate youur shutdown via systemd on the success of that operation. Brad.
