Re: last_archived_wal is not necessary the latest WAL file (was Re: pgsql: Add test case for an archive recovery corner case.)
Noah Misch <noah@leadboat.com>
From: Noah Misch <noah@leadboat.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2022-06-30T05:03:10Z
Lists: pgsql-hackers
On Mon, Jun 27, 2022 at 07:32:08PM +0900, Michael Paquier wrote:
> On Mon, Jun 27, 2022 at 12:04:57AM -0700, Noah Misch wrote:
> > One can adapt the test to the server behavior by having the test wait for the
> > archiver to start, as attached. This is sufficient to make check-world pass
> > with the above sleep in place. I think we should also modify the PostgresNode
> > archive_command to log a message. That lack of logging was a obstacle
> > upthread (as seen in commit 3279cef) and again here.
>
> ? qq{copy "%p" "$path\\\\%f"}
> - : qq{cp "%p" "$path/%f"};
> + : qq{echo >&2 "ARCHIVE_COMMAND %p"; cp "%p" "$path/%f"};
>
> This is a bit inelegant. Perhaps it would be better through a perl
> wrapper like cp_history_files?
I see it the other way. Replacing a 49-character compound command with a
wrapper script would gain no particular advantage, and it would give readers
of the test code one more file to open and understand.
Commits
-
Fix race condition in t/028_pitr_timelines.pl.
- 0806cd29be01 15.0 landed
- 4f4c72c2dc06 16.0 landed
-
Fix race condition in 028_pitr_timelines.pl test, add note to docs.
- 853c6400bf5d 15.0 landed
-
Add more logging to new 028_pitr_timelines.pl test.
- 3279cef0727a 15.0 cited
-
Add test case for an archive recovery corner case.
- 50e5bc582a43 15.0 cited