References: 
 <CAEUA1803mcfTcdh61ncSFsLQ734kuci337ojoMLWwCqx9UFp0Q@mail.gmail.com>
Message-ID: <1407082358.86070.YahooMailNeo@web122306.mail.ne1.yahoo.com>
Date: Sun, 3 Aug 2014 09:12:38 -0700
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: PITR WAL Restore and configuration
To: Techie <techchavez@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CAEUA1803mcfTcdh61ncSFsLQ734kuci337ojoMLWwCqx9UFp0Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Techie <techchavez@gmail.com> wrote:

> let's say for example I want to restore the Base Backup from 6
> months ago, I only have the Base Backups.. Will I be able to
> recover to that point in time using that Base backup?

Not without all of the WAL files from the point pg_start_backup()=20
was run until the point pg_stop_backup() was run.=A0 Earlier WAL=20
files won't matter.=A0 You will be able to restore to any point in=20
time from when pg_stop_backup() onward as long as you have an=20
unbroken series of WAL files (and any .history files which were=20
generated).

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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