To: Virupaksha Kanjilal <v.kanjilal@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: WAL files required to make base backup consistent
References: 
 <CADm2AyPy979npts3B6cNHX8dvgbrTJ1A0FKn9aXWD94NYb07LA@mail.gmail.com>
From: Jerry Sievers <gsievers19@comcast.net>
Date: Tue, 28 May 2013 17:03:41 -0500
In-Reply-To: 
 <CADm2AyPy979npts3B6cNHX8dvgbrTJ1A0FKn9aXWD94NYb07LA@mail.gmail.com>
	(Virupaksha Kanjilal's message of "Wed\,
	22 May 2013 14\:30\:26 -0700")
Message-ID: <87ppwa3goy.fsf@comcast.net>
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Virupaksha Kanjilal <v.kanjilal@gmail.com> writes:

> 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?

Look in your WAL repository for files named *.backup.

The prefix part will match the name of a regular WALf file from when
the backup was started and the .backup file itself will contain some
human readable text indicating the last WAL segment that you'll need
for a consistent recovery.

HTH

> Thanks
> Viru
>

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin