Re: WAL files required to make base backup consistent

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Virupaksha Kanjilal <v(dot)kanjilal(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL files required to make base backup consistent
Date: 2013-05-23 00:21:47
Message-ID: CA+HiwqF_XhnL1m8Vy18+Nh8_7SV7w5CJp-znfwN2c6nwfqOecA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 23, 2013 at 6:30 AM, Virupaksha Kanjilal
<v(dot)kanjilal(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dev Kumkar 2013-05-23 01:06:05 Re: [ODBC] ODBC constructs
Previous Message Dev Kumkar 2013-05-22 21:38:06 Re: [ODBC] ODBC constructs