From: Simon Riggs <simon@2ndquadrant.com>
To: Pallav Kalva <pkalva@deg.cc>
To: Morus Walter <morus.walter@tanto.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Online Backup and WAL archives
Date: Thu, 3 Feb 2005 21:42:47 -0800
Message-ID: <KGEFLMPJFBNNLNOOOPLGEEFHCIAA.simon@2ndquadrant.com> (raw)
In-Reply-To: <42023B3A.9010703@deg.cc>
>Pallav Kalva wrote
> yes, documentation points to the
> recovery_target_time(timestamp) option
> in this regard, sorry i missed that. but there is one thing which is
> still not clear to me is if we restore the database to some
> time back ,
> what happens to WAL files in the pg_xlog directory ?
>if we
> still keep
> those files there,
The manual asks you not to do this, in 22.3.3 step 5
so why wonder too much about what will happen?
> arent they out of sync ?
No.
> since we are
> going back in
> time and we dont need the WAL logs after the
> recovery_target_time(timestamp), or is it that restore command takes
> care everything automatically ? the manual doesnt clearly say what
> happens to the WAL logs in pg_xlog in case if we use the
> recovery_target_time(timestamp) option.
Read 22.3.4 and it will become clearer.
Better still, try it and see for yourself. About 3 times, so you're
certain you understand how it works before you begin using it and
relying on it.
The xlog filenames are prefixed by the timelineId, which prevents the
server from becoming confused about the files.
Best regards, Simon Riggs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, pkalva@deg.cc, morus.walter@tanto.de
Subject: Re: Online Backup and WAL archives
In-Reply-To: <KGEFLMPJFBNNLNOOOPLGEEFHCIAA.simon@2ndquadrant.com>
References: <42023B3A.9010703@deg.cc> <KGEFLMPJFBNNLNOOOPLGEEFHCIAA.simon@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox