Re: Forcing WAL switch - Mailing list pgsql-novice

From Tom Lane
Subject Re: Forcing WAL switch
Date
Msg-id 25201.1123798290@sss.pgh.pa.us
Whole thread Raw
In response to Re: Forcing WAL switch  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
List pgsql-novice
"Walker, Jed S" <Jed_Walker@cable.comcast.com> writes:
> If the backup completes, I switch the database out of "backup mode", and
> then switch a WAL and it archives, then I know my backup directory
> contains the backup and the WAL(s) needed to bring the database to a
> consistent state. So, if I can switch a WAL after the backup, then I
> truly have a complete backup.

How is "switch a WAL" an essential component of that scheme?  You can
archive the latest active segment just as well.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Walker, Jed S"
Date:
Subject: Re: Forcing WAL switch
Next
From: "Walker, Jed S"
Date:
Subject: Re: Forcing WAL switch