Re: Recovery of .partial WAL segments - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject Re: Recovery of .partial WAL segments
Date
Msg-id jj4b3wolr7gt3rjjvv7yw2luv5kho7s4t5sizwoq4vjbdsxvce@twycelwxpdxq
Whole thread Raw
In response to Re: Recovery of .partial WAL segments  (Stefan Fercot <stefan.fercot@dataegret.com>)
Responses Re: Recovery of .partial WAL segments
List 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.



pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Re: Add trim_trailing_whitespace to editorconfig file
Next
From: Nathan Bossart
Date:
Subject: Re: optimizing pg_upgrade's once-in-each-database steps