Re: Remove Deprecated Exclusive Backup Mode

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: David Steele <david(at)pgmasters(dot)net>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Stephen Frost <sfrost(at)snowman(dot)net>, Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Remove Deprecated Exclusive Backup Mode
Date: 2019-02-26 17:32:12
Message-ID: CAHGQGwGeFR9nwZEE3Wq1at3unvKXUnvBOjn1zPFvt0iZ6AyZZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 27, 2019 at 2:27 AM Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
> On Tue, Feb 26, 2019 at 12:20 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> > So, let me clarify the situations;
> >
> > (1) If backup_label and recovery.signal exist, the recovery starts safely.
> > This is the normal case of recovery from the base backup.
> >
> > (2)If backup_label.pending and recovery.signal exist, as described above,
> > PANIC error happens at the start of recovery. This case can happen
> > if the operator forgets to rename backup_label.pending, i.e.,
> > operation mistake. So, after PANIC, the operator needs to fix her or
> > his mistake (i.e., rename backup_label.pending) and restart
> > the recovery.
> >
> > (3) If backup_label.pending exists but recovery.signal doesn't, the server
> > ignores (or removes) backup_label.pending and do the recovery
> > starting the pg_control's REDO location. This case can happen if
> > the server crashes while an exclusive backup is in progress.
> > So crash-in-the-middle-of-backup doesn't prevent the recovery from
> > starting in this idea.
>
> The if-conditions for 1 and 2 appear to be the same, which is confusing.

Using other name like backup_in_progress instead of backup_label.pending
may help a bit for your concern? That is,

(1) backup_label and recovery.signal
(2) backup_in_progress and recovery.signal

Regards,

--
Fujii Masao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-02-26 17:33:12 Re: Remove Deprecated Exclusive Backup Mode
Previous Message Christophe Pettus 2019-02-26 17:31:28 Re: Remove Deprecated Exclusive Backup Mode