Re: Recovery of .partial WAL segments

From: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
To: Stefan Fercot <stefan(dot)fercot(at)dataegret(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Recovery of .partial WAL segments
Date: 2024-08-09 14:29:48
Message-ID: jj4b3wolr7gt3rjjvv7yw2luv5kho7s4t5sizwoq4vjbdsxvce@twycelwxpdxq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Fri, Aug 02, 2024 at 08:47:02AM GMT, Stefan Fercot wrote:
>
> Not sure why CFbot CI fails on macOS/Windows while it works with the Github
> CI on my fork (
> https://cirrus-ci.com/github/pgstef/postgres/partial-walseg-recovery)

I guess it's because the test has to wait a bit after the node has been
started until the log lines will appear. One can see it in the
node_pitr3 logs, first it was hit by

SELECT pg_is_in_recovery() = 'f'

and only some moments later produced

restored log file "000000010000000000000003.partial" from archive

where the test has those operations in reversed order. Seems like the
retry loop from 019_replslot_limit might help.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2024-08-09 14:43:59 Re: optimizing pg_upgrade's once-in-each-database steps
Previous Message Jelte Fennema-Nio 2024-08-09 14:09:59 Re: Add trim_trailing_whitespace to editorconfig file