pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>
>  
>





view thread (10+ messages)  latest in thread

Message-ID: <42023B3A.9010703@deg.cc>
Permalink:  ../42023B3A.9010703@deg.cc/
Also on:    postgresql.org/message-id/42023B3A.9010703@deg.cc

 · 

reply

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