Re: WAL files required to make base backup consistent - Mailing list pgsql-admin

From Amit Langote
Subject Re: WAL files required to make base backup consistent
Date
Msg-id CA+HiwqF_XhnL1m8Vy18+Nh8_7SV7w5CJp-znfwN2c6nwfqOecA@mail.gmail.com
Whole thread Raw
In response to WAL files required to make base backup consistent  (Virupaksha Kanjilal <v.kanjilal@gmail.com>)
List pgsql-admin
On Thu, May 23, 2013 at 6:30 AM, Virupaksha Kanjilal
<v.kanjilal@gmail.com> wrote:
> Hi
>
> I perform a pg_basebackup with tar option and do not bring in the WAL
> segments created during the backup. Now I want to make the backup a
> consistent copy and for that I need the WAL segments. How can I know which
> all WAL segments to apply to bring the backup to a consistent state?
>

By "bringing backup to a consistent state", you mean "restoring from
it to a consistent state", right?
Do you have archiving turned on?

--
Amit Langote


pgsql-admin by date:

Previous
From: Virupaksha Kanjilal
Date:
Subject: WAL files required to make base backup consistent
Next
From: Amit Langote
Date:
Subject: Re: WAL files not following sequence