Re: Startup PANIC on standby promotion due to zero-filled WAL segment

Поиск

Список

Период

Сортировка

От	Alena Vinter
Тема	Re: Startup PANIC on standby promotion due to zero-filled WAL segment
Дата	25 декабря 11:47:05
Msg-id	CAGWv16+9r8roFdReY1qV6rcFDi9UdzmjQc+GfKbdvHZMomCqCg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Startup PANIC on standby promotion due to zero-filled WAL segment (Michael Paquier <michael@paquier.xyz>)
Список	pgsql-hackers

I like the idea of preventing promotion to avoid such failures -- it sounds reasonable.

However, we still have the problem: if the standby is stopped with non-replicated TLI 2, it will fail to start:

"FATAL: according to history file, WAL location Y belongs to timeline X, but previous recovered WAL file came from timeline X+1".

This happens even if no promotion is attempted — just a plain restart of the standby. So the issue isn’t only about when to allow promotion.

Regarding my proposed solution: could you clarify why it isn’t correct? I’d appreciate more detail so I can address your concerns.

---

Alena Vinter

В списке pgsql-hackers по дате отправления: