Re: pg_veryfybackup can fail with a valid backup for TLI > 1

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pg_veryfybackup can fail with a valid backup for TLI > 1
Date: 2021-08-20 07:23:56
Message-ID: YR9YjIiOK9pFQhQO@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 20, 2021 at 03:33:37PM +0900, Kyotaro Horiguchi wrote:
> That's looks like a domino falling. I had the following result, which
> looks fine.
>
> "WAL-Ranges": [
> { "Timeline": 6, "Start-LSN": "0/630C7E8", "End-LSN": "0/630C850" },
> { "Timeline": 5, "Start-LSN": "0/630C780", "End-LSN": "0/630C7E8" },
> { "Timeline": 4, "Start-LSN": "0/630C718", "End-LSN": "0/630C780" },
> { "Timeline": 3, "Start-LSN": "0/630C6B0", "End-LSN": "0/630C718" },
> { "Timeline": 2, "Start-LSN": "0/5000028", "End-LSN": "0/630C6B0" }
> ],
>
> 00000006.history:
> 1 0/173F268 no recovery target specified
> 2 0/630C6B0 no recovery target specified
> 3 0/630C718 no recovery target specified
> 4 0/630C780 no recovery target specified
> 5 0/630C7E8 no recovery target specified

And your backup_label shows 0/5000028 as start LSN for the backup,
right? I see the same result.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Pyhalov 2021-08-20 07:36:08 Re: Push down time-related SQLValue functions to foreign server
Previous Message Alexander Pyhalov 2021-08-20 07:13:30 Re: Push down time-related SQLValue functions to foreign server