From: 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, 03 Feb 2005 09:54:50 -0500
Message-ID: <42023B3A.9010703@deg.cc> (raw)
In-Reply-To: <16896.60593.751654.61839@tanto-xipolis.de>
References: <16895.32035.914311.612690@tanto-xipolis.de>
<15479.1107277351@sss.pgh.pa.us>
<4200E2DC.6020803@deg.cc>
<16896.60593.751654.61839@tanto-xipolis.de>
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, arent they out of sync ? 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.
In Oracle i know that there is a option of resetting the logs if we have
to restore some time in back, not sure how it works in new Postgres 8.
Morus Walter wrote:
>Pallav Kalva writes:
>
>
>> If I want to restore to a particular point in time lets say to the
>>point in time like a day back when one of my table was dropped
>>accidentally and if i want restore the archive log only to that
>>particular archive log file . what is the procedure we should follow ?
>>just keep the archive logs in the directory until the last archive log
>>file i need or is there a command something like " restore only until
>>at this archive log file " ? Also what happens to the transaction log
>>files in pg_xlog directory in this scenario ? do i have to still keep
>>them or they get created by themself since i am going a day back ?
>>
>> Is this possible in postgres 8
>>
>>
>>
>Yes. That's what PITR is about. Read the manual for details.
>If you look at the recovery.conf.sample you'll find a variable
>recovery_target_time that must be set. Unless I missed something this
>isn't explicitly stated in the docs but the comment in the sample conf
>is pretty clear.
>Alternatively you can define a transaction id (recovery_target_xid).
>
>Of course you must have a backup created before the incident and all WALs
>up to the time of the incident.
>
>Morus
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
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: pkalva@deg.cc, morus.walter@tanto.de
Subject: Re: Online Backup and WAL archives
In-Reply-To: <42023B3A.9010703@deg.cc>
References: <16895.32035.914311.612690@tanto-xipolis.de> <15479.1107277351@sss.pgh.pa.us> <4200E2DC.6020803@deg.cc> <16896.60593.751654.61839@tanto-xipolis.de> <42023B3A.9010703@deg.cc>
* 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