Re: BUG #19032: In restore_command %f parameter does not support WAL partial files. - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19032: In restore_command %f parameter does not support WAL partial files.
Date
Msg-id CAKFQuwYZ8kq3_ELyHe2vcaXkD2o_hbJXsAHFTgZdufqe4bK2NA@mail.gmail.com
Whole thread Raw
In response to BUG #19032: In restore_command %f parameter does not support WAL partial files.  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #19032: In restore_command %f parameter does not support WAL partial files.
List pgsql-bugs
On Tue, Aug 26, 2025 at 5:10 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      19032
Logged by:          Wojciech Szenajch
Email address:      wszenajch@gmail.com
PostgreSQL version: 17.6
Operating system:   Ubuntu 24.04.03 LTS
Description:       

Using restore_command = 'cp /tmp/receivewal/%f %p' does not use WAL partial
file during backup restore process.

While this seems un-documented in the user-facing documentation the source code makes it clear this is intended behavior.  If your point-in-time-recovery flow requires the use of these files you will need to manually manipulate them.


(link to article about a custom archiving process relying on pg_receivewal)

It seems unfortunate that the pg_receivewal creates files with ".partial" extensions that are semantically different from what the core system ".partial" files are.  But if your archive process is custom (i.e., uses something other than archive_command) it seems reasonable that any restore_command you need to create would also be something custom.  Going by the documentation for only half of the process is going to lead to these kinds of inconsistent results.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19031: pg_trgm infinite loop on certain cases
Next
From: "Nantha kumar.T."
Date:
Subject: Re: [CAUTION: SUSPECT SENDER] RE: [CAUTION: SUSPECT SENDER] RE: BUG #19029: Replication Slot size keeps increasing while logical subscription works fine