Re: 12.2: Why do my Redo Logs disappear??
От | Peter Geoghegan |
---|---|
Тема | Re: 12.2: Why do my Redo Logs disappear?? |
Дата | |
Msg-id | CAH2-WzkW4deJz2WfwAw5LuK+s_nKHJkfA4WxXYS+OObnQ47jYA@mail.gmail.com обсуждение исходный текст |
Ответ на | 12.2: Why do my Redo Logs disappear?? (Peter <pmc@citylink.dinoex.sub.org>) |
Ответы |
Re: 12.2: Why do my Redo Logs disappear??
|
Список | pgsql-general |
On Mon, Jun 8, 2020 at 5:17 PM Peter <pmc@citylink.dinoex.sub.org> wrote: > Loosing a RedoLog is very bad, because there is no redundancy, > loosing a single one of them makes the timeline disappear and it > will only reappear after another Base Backup. Very very bad. > In this case, it seems, Postgres will delete the current log > without archiving it. :( I strongly suspect that you were hit by the bug fixed in commit 4e87c483. You should upgrade to Postgres 12.3 ASAP, to get that fix: "Avoid premature recycling of WAL segments during crash recovery (Jehan-Guillaume de Rorthais) WAL segments that become ready to be archived during crash recovery were potentially recycled without being archived." Sorry that you were affected by this bug -- it really sucks. -- Peter Geoghegan
В списке pgsql-general по дате отправления: