Re: AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Brad Nicholson
"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 + sy

AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Zwettler Markus (OIZ)
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:

Re: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Brad Nicholson
"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: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Zwettler Markus (OIZ)
t;> > 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: b

Re: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Brad Nicholson
"Zwettler Markus (OIZ)" wrote on 2019/11/08 11:02:49 AM: > From: "Zwettler Markus (OIZ)" > To: Brad Nicholson > Cc: Adrian Klaver , "pgsql- > gene...@lists.postgresql.org" > Date: 2019/11/08 11:02 AM > Subject: [EXTERNAL] AW: AW: AW: AW: AW:

AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Zwettler Markus (OIZ)
ler Markus (OIZ) Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org Betreff: Re: 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 07:51:33 AM:

Re: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Brad Nicholson
"Zwettler Markus (OIZ)" wrote on 2019/11/08 07:51:33 AM: > From: "Zwettler Markus (OIZ)" > To: Brad Nicholson > Cc: Adrian Klaver , "pgsql- > gene...@lists.postgresql.org" > Date: 2019/11/08 07:51 AM > Subject: [EXTERNAL] AW: AW: AW: AW:

AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-08 Thread Zwettler Markus (OIZ)
uot; > mailto:pgsql-general@lists.postgresql.org>> > Date: 2019/11/07 11:33 AM > Subject: [EXTERNAL] AW: AW: AW: broken backup trail in case of > quickly patroni switchback and forth > > 3) > Patroni does only failovers. Also in case of regular shutdown of the > pri

Re: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-07 Thread Brad Nicholson
"Zwettler Markus (OIZ)" wrote on 2019/11/07 11:32:42 AM: > From: "Zwettler Markus (OIZ)" > To: Adrian Klaver , "pgsql- > gene...@lists.postgresql.org" > Date: 2019/11/07 11:33 AM > Subject: [EXTERNAL] AW: AW: AW: broken backup trail in case of

AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth

2019-11-07 Thread Zwettler Markus (OIZ)
3) Patroni does only failovers. Also in case of regular shutdown of the primary. A failover is a promote of the standby + automatic reinstate (pg_rewind or pg_basebackup) of the former primary. Time: role site 1 - role site 2 12:00h: primary - standby => Some clients commite