Request a Demo
Home   >   mailing lists

Questions about the continuity of WAL archiving - Mailing list pgsql-general

From px shi
Subject Questions about the continuity of WAL archiving
Date
Msg-id CAAccyYKpNsQMD+S-A7a8YtDevFN0uRXkzg4tYWWBOFsv_jASNg@mail.gmail.com
Whole thread Raw
Responses Re: Questions about the continuity of WAL archiving
Re: Questions about the continuity of WAL archiving
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Charles Qi
Date:
Subject: Re: When UPDATE a row in a table with BEFORE ROW UPDATE trigger, the XMAX of new tuple is set to current XID
Next
From: Adrian Klaver
Date:
Subject: Re: Questions about the continuity of WAL archiving