Failover messages in Timeline History - Mailing list pgsql-hackers

From Michael Banck
Subject Failover messages in Timeline History
Date
Msg-id 45d13db2b4805d597bc86eafba3bd2324025e1e8.camel@credativ.de
Whole thread Raw
List pgsql-hackers
Hi,

if a failover (or probably a switchover, at least in the way Patroni
does it) occurs, the timeline history (e.g. via "patronictl history"[1])
seems to read "no recovery target specified". That's correct, of course,
from a PITR perspective, but for the (possibly more common?) promotion-
of-a-standby-due-to-failover/switchover case rather misleading.

I wonder whether it could be made more informative; like "no recovery
target or failover" or "(standby) promotion witout recovery target"?


Michael

[1]

root@pg1:~# patronictl -c /etc/patroni/13-main.yml history | head
+----+----------+------------------------------+----------------------------------+
| TL |      LSN | Reason                       | Timestamp                        |
+----+----------+------------------------------+----------------------------------+
|  1 | 83886296 | no recovery target specified | 2021-06-18T20:04:11.645437+00:00 |
|  2 | 83886928 | no recovery target specified | 2021-06-18T20:08:45.820304+00:00 |
|  3 | 83887384 | no recovery target specified | 2021-06-19T05:57:50.431980+00:00 |
|  4 | 83887840 | no recovery target specified | 2021-06-19T08:32:55.527975+00:00 |
|  5 | 84017040 | no recovery target specified | 2021-06-19T12:05:40.495982+00:00 |
|  6 | 84019264 | no recovery target specified | 2021-06-19T15:51:49.983987+00:00 |
|  7 | 84135720 | no recovery target specified | 2021-06-20T03:46:22.775851+00:00 |

-- 
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax:  +49 2166 9901-100
Email: 
michael.banck@credativ.de
credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Sascha Heuer

Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: 
https://www.credativ.de/datenschutz




pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: [PATCH] Make jsonapi usable from libpq
Next
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors