Re: BUG #14326: Unexpected status after crash during exclusive backup

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #14326: Unexpected status after crash during exclusive backup
Дата
Msg-id CAB7nPqT7grAX+7aJLd4Z-3f-haOV1f2A6ZCnK9v-6i=kFPe9qQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14326: Unexpected status after crash during exclusive backup  (marco.nenciarini@2ndquadrant.it)
Ответы Re: BUG #14326: Unexpected status after crash during exclusive backup
Список pgsql-bugs
On Fri, Sep 16, 2016 at 6:54 PM,  <marco.nenciarini@2ndquadrant.it> wrote:
> The workaround I found to reset this state is to force the instance through
> another backup recovery, by starting an exclusive backup, saving the
> backup_label, stopping the backup and restarting the instance with the saved
> backup_label in place.

That's not user-friendly.

> I don't know the best way to handle this situation, but at least, I'd like a
> warning message when the instance exits from the crash recovery while
> backupStartPoint is still set.

So you would get such a warning even when you restore from a backup
willingly, no? That may confuse users. Now, the case you are referring
to is unfortunately a known problem with exclusive backups... There is
no way to make the difference between a node restored from a backup
and a node that crashed while a backup is taken. And that may be a
reason to make non-exclusive backups more popular because they are
more reliable.
--
Michael

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #14330: can not select into `composite data types` in plpgsql