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
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 |