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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: marco(dot)nenciarini(at)2ndquadrant(dot)it
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14326: Unexpected status after crash during exclusive backup
Date: 2016-09-21 06:50:18
Message-ID: CAB7nPqT7grAX+7aJLd4Z-3f-haOV1f2A6ZCnK9v-6i=kFPe9qQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Sep 16, 2016 at 6:54 PM, <marco(dot)nenciarini(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2016-09-21 07:12:33 Re: BUG #14330: can not select into `composite data types` in plpgsql
Previous Message Michael Paquier 2016-09-21 04:17:04 Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file