Re: out-of-order XID insertion in KnownAssignedXids

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: out-of-order XID insertion in KnownAssignedXids
Дата
Msg-id 20161020203826.cmccyipkvfa2r2fn@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: out-of-order XID insertion in KnownAssignedXids  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: out-of-order XID insertion in KnownAssignedXids  (<fredrik@huitfeldt.com>)
Список pgsql-general
On 2016-10-20 22:37:15 +0900, Michael Paquier wrote:
> On Thu, Oct 20, 2016 at 10:21 PM,  <fredrik@huitfeldt.com> wrote:
> > - remove a file called backup_label, but I am not certain that this file is
> > in fact there (any more).
>
> It is never a good idea when you are trying to restore from a backup,
> backup_label contains critical information when restoring from a
> backup, so you may finish with a corrupted data folder.

And this actually seems like a likely source of these errors.  Removing
a backup label unfortunately causes hard to diagnose errors, because
everything appears to be ok as long as there's no checkpoints while
taking the base backups (or when the control file was copied early
enough). But as soon as a second checkpoint happens before the control
file is copied...

Fredrik, how did you end up removing the label?

Greetings,

Andres Freund


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Postgresql apt repository naming scheme question
Следующее
От: Арсений Нестюк
Дата:
Сообщение: Showing matrix with single query