"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
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:
"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:
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
"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:
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:
"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:
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
1) If I got you right this means enabling archiving on both machines
(archive_mode=on, archive_command=cp...). Yes?
2) Will the latest transactions on the actual primary be archived (copied from
pg_xlog to the local archive_directory) before this primary is reinstated as
new standby?
Thanks,
M
"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
On Thu, 2019-11-07 at 13:52 +, Zwettler Markus (OIZ) wrote:
> we are using Patroni for management of our Postgres standby databases.
>
> we take our (wal) backups on the primary side based on intervals and
> thresholds.
> our archived wal's are written to a local wal directory first and moved
osync: false
-Ursprüngliche Nachricht-
Von: Adrian Klaver
Gesendet: Donnerstag, 7. November 2019 17:06
An: Zwettler Markus (OIZ) ;
pgsql-general@lists.postgresql.org
Betreff: Re: AW: AW: broken backup trail in case of quickly patroni switchback
and forth
On 11/7/19 7:47 AM, Zwettler Markus (OIZ)
On 11/7/19 7:47 AM, Zwettler Markus (OIZ) wrote:
I am heading out the door so I will not have time to look at below until
later. For those that get a chance before then, it would be nice to have
the Patroni conf file information also. The Patroni information may
answer the question, but it cas
1) 9.6
2)
$ cat postgresql.conf
# Do not edit this file manually!
# It will be overwritten by Patroni!
include 'postgresql.base.conf'
cluster_name = 'pcl_l702'
hot_standby = 'on'
hot_standby_feedback = 'True'
listen_addresses =
'localhost,tstm49003.tstglobal.tst.loc,pcl_l702.tstglobal.tst.loc
On 11/7/19 7:18 AM, Zwettler Markus (OIZ) wrote:
I already asked the Patroni folks. They told me this is not related to Patroni
but Postgresql. ;-)
Hard to say without more information:
1) Postgres version
2) Setup/config info
3) Detail if what happened between 12:00 and 12:10
- Markus
I already asked the Patroni folks. They told me this is not related to Patroni
but Postgresql. ;-)
- Markus
On 11/7/19 5:52 AM, Zwettler Markus (OIZ) wrote:
> we are using Patroni for management of our Postgres standby databases.
>
> we take our (wal) backups on the primary side based on inte
On 11/7/19 5:52 AM, Zwettler Markus (OIZ) wrote:
we are using Patroni for management of our Postgres standby databases.
we take our (wal) backups on the primary side based on intervals and thresholds.
our archived wal's are written to a local wal directory first and moved to tape
afterwards.
w
we are using Patroni for management of our Postgres standby databases.
we take our (wal) backups on the primary side based on intervals and thresholds.
our archived wal's are written to a local wal directory first and moved to tape
afterwards.
we got a case where Patroni switched back and forth
18 matches
Mail list logo
