public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dmitry Litvintsev <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: could not stat file "pg_wal/RECOVERYHISTORY": No such file or director
Date: Thu, 23 Oct 2025 21:54:38 +0000
Message-ID: <SA1PR09MB7311F515AD3175FFF615523EB9F0A@SA1PR09MB7311.namprd09.prod.outlook.com> (raw)
Hello,
I have been setting PITR backup off of base backup. Wal files are shipped to the host running pg_basebackup pulling backup from
master host.
Once base backup finished I wanted to try recovery.
I added
restore_command = 'gunzip /data/xlogs/%f.gz > %p'
(that command is wrapped in a script that checks existence of input and exits w/ 0 if it does not as per instructions)
I did move pg_wal out of the way and re-created it:
mv pg_wal pg_wal.bak
mkdir pg_wal
I did touch recovery signal:
touch recovery.signal
I see in the log:
< 2025-10-23 16:05:30.750 CDT 2876871 > LOG: database system was interrupted; last known up at 2025-10-23 02:00:41 CDT
< 2025-10-23 16:05:31.582 CDT 2876871 > LOG: could not stat file "pg_wal/RECOVERYHISTORY": No such file or directory
< 2025-10-23 16:05:31.582 CDT 2876871 > DETAIL: restore_command returned a zero exit status, but stat() failed.
< 2025-10-23 16:05:31.582 CDT 2876871 > LOG: starting archive recovery
< 2025-10-23 16:05:31.583 CDT 2876871 > LOG: starting backup recovery with redo LSN 20975/FE0AC690, checkpoint LSN 20975/FE21CA88, on timeline ID 4
< 2025-10-23 16:05:31.586 CDT 2876871 > LOG: could not stat file "pg_wal/RECOVERYHISTORY": No such file or directory
< 2025-10-23 16:05:31.586 CDT 2876871 > DETAIL: restore_command returned a zero exit status, but stat() failed.
< 2025-10-23 16:05:31.798 CDT 2876871 > LOG: restored log file "0000000400020975000000FE" from archive
< 2025-10-23 16:05:31.819 CDT 2876871 > LOG: redo starts at 20975/FE0AC690
< 2025-10-23 16:05:33.927 CDT 2876871 > LOG: restored log file "0000000400020975000000FF" from archive
it seems to be churning on, but I am a bit worried about :
could not stat file "pg_wal/RECOVERYHISTORY": No such file or directory
I do not recall having to deal with this in the past? Should I have manually created
pg_wal/archive_status
my old scripts seem to indicate the need for this - I am trying to resurrect
PITR after multiple upgrades and not running it for some time (relying in replica instead)
So, is it harmless? Postgresql does not fail, the recovery is still ongoing.
This is postgresql 15.
Additional question.... as the wall file are continuously getting shipped to the backup host,
will this recovery ever end? (I neglected to set recovery_target_time)
Thank you very much in advance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: could not stat file "pg_wal/RECOVERYHISTORY": No such file or director
In-Reply-To: <SA1PR09MB7311F515AD3175FFF615523EB9F0A@SA1PR09MB7311.namprd09.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox