Questions about the continuity of WAL archiving

From: px shi <spxlyy123(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Questions about the continuity of WAL archiving
Date: 2025-08-08 03:20:59
Message-ID: CAAccyYKpNsQMD+S-A7a8YtDevFN0uRXkzg4tYWWBOFsv_jASNg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
There is a scenario: the current timeline of the PostgreSQL primary node is
1, and the latest WAL file is 100. The standby node has also received up to
WAL file 100. However, the latest WAL file archived is only file 80. If the
primary node crashes at this point and the standby is promoted to the new
primary, archiving will resume from file 100 on timeline 2. As a result,
WAL files from 81 to 100 on timeline 1 will be missing from the archive.
Is there a good solution to prevent this situation?

Regards,
Pixian Shi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-08-08 04:25:30 Re: Questions about the continuity of WAL archiving
Previous Message Charles Qi 2025-08-08 01:20:00 Re: When UPDATE a row in a table with BEFORE ROW UPDATE trigger, the XMAX of new tuple is set to current XID