On 3/24/17 12:27 AM, Peter Eisentraut wrote:
> On 3/23/17 16:58, Stephen Frost wrote:
>> The backup tools need to also get the LSN from the pg_stop_backup and
>> verify that they have the WAL file associated with that LSN.
>
> There is a function for that.
>
>> They also
>> need to make sure that they have all of the WAL files between the
>> starting LSN and the ending LSN. Doing that requires understanding how
>> the files are named to make sure there aren't any missing.
>
> There is not a function for that, but there could be one.
A function would be nice, but tools often cannot depend on the database
being operational so it's still necessary to re-implement them. Having
a sane sequence in the WAL makes that easier.
--
-David
david@pgmasters.net