Thread

  1. Re: Making WAL archiving faster — multi-file support and async ideas

    Greg Sabino Mullane <htamfids@gmail.com> — 2025-08-25T13:38:16Z

    On Mon, Aug 25, 2025 at 4:31 AM Alyona Vinter <dlaaren8@gmail.com> wrote:
    
    > ... could attempt a restore using the incomplete archive. While we hope
    > this would cause a clear error during recovery, there is a risk that
    > partial application of non-sequential segments might lead to silent
    > corruption or other unforeseen issues.
    >
    
    Can you expand on how that could happen? Postgres knows the name of the
    next WAL to look for, so it's not going to ever jump over a missing file.
    
    Cheers,
    Greg
    
    --
    Crunchy Data - https://www.crunchydata.com
    Enterprise Postgres Software Products & Tech Support