X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CAEFA9FA31F for ; Thu, 13 Jul 2006 12:20:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09536-03 for ; Thu, 13 Jul 2006 12:20:22 -0300 (ADT) X-Greylist: whitelisted by SQLgrey- Received: from motgate3.mot.com (motgate3.mot.com [144.189.100.103]) by postgresql.org (Postfix) with ESMTP id CCB539FB1C9 for ; Thu, 13 Jul 2006 12:20:20 -0300 (ADT) Received: from az33exr03.mot.com (az33exr03.mot.com [10.64.251.233]) by motgate3.mot.com (8.12.11/Motgate3) with ESMTP id k6DFKJtw013615 for ; Thu, 13 Jul 2006 08:20:19 -0700 (MST) Received: from ZMY16EXM67.ds.mot.com (zmy16exm67.ap.mot.com [10.179.4.27]) by az33exr03.mot.com (8.13.1/8.13.0) with ESMTP id k6DFKH69001430 for ; Thu, 13 Jul 2006 10:20:18 -0500 (CDT) Received: from motorola.com ([10.232.112.87]) by ZMY16EXM67.ds.mot.com with Microsoft SMTPSVC(6.0.3790.211); Thu, 13 Jul 2006 23:20:16 +0800 Message-ID: <44B662F3.50208@motorola.com> Date: Thu, 13 Jul 2006 20:42:51 +0530 From: Satya Prakash Tripathi User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: Satya Prakash Tripathi Subject: Re: Fwd: PITR- timeline query References: <20060713151839.46359.qmail@web52001.mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------000304030201020107050607" X-OriginalArrivalTime: 13 Jul 2006 15:20:16.0596 (UTC) FILETIME=[D84AE940:01C6A68F] X-Brightmail-Tracker: AAAAAQAAAAQ= X-White-List-Member: TRUE X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/131 X-Sequence-Number: 22377 --------------000304030201020107050607 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit > > > > > > >Hi , > >I am experimenting with PITR aspect of postgres8.0, >and I needed some answers on this subject. > >I have following questions : > >1) >At time t0, I created a base backup. (got a backup >marker file named as: >0000000800000002000000A8.005E61B4.backup) >(assume no previous base backups and recoveries...) > >On time t2 I did a recovery till time t1 ( t0Now I see history file named 00000009.history. And >then onwards, the WAL filenames start with 00000009. >Is 00000009 here the new timeline ? If so is it safe >to deduce that from .history file that gets generated >after recovery ? > >2) >Now say, I was happy with the above recovery and after >a few days, at time t3 I decided to revover my db back >in time t. > >What timeline should I specify in recovery.conf if: >(or do I need to specify it in each case?) > > a) t1 < t < t2 > b) t2 < t < t3 > >IMO, in case a) the timeline of base backup would be >used, so I wouldn't need to specify timeline. While in >case b) I need to specify this new >timeline(recovery_target_timeline=00000009). >Kindly confirm... > >trying to put the scenario pictorially: > > t0 t2 > | t1 | > |-------| ------ |---------- timeline: 00000008 > | > | timeline:00000009 > |----------------------|---- > t3 > > > >TIA, >Satya > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > > --------------000304030201020107050607 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit





Hi ,

I am experimenting with PITR aspect of postgres8.0,
and I needed some answers on this subject.

I have following questions :

1)
At time t0, I created a base backup. (got a backup
marker file named as:
0000000800000002000000A8.005E61B4.backup) 
(assume no previous base backups and recoveries...)

On time t2 I did a recovery till time t1 ( t0<t1<t2).
Now I see history file named 00000009.history. And
then onwards, the WAL filenames start with 00000009. 
Is 00000009 here the new timeline ? If so is it safe
to deduce that from .history file that gets generated
after recovery ?

2)
Now say, I was happy with the above recovery and after
a few days, at time t3 I decided to revover my db back
in time t.

What timeline should I specify in recovery.conf if:
(or do I need to specify it in each case?)

  a)  t1 < t < t2
  b)  t2 < t < t3

IMO,  in case a) the timeline of base backup would be
used, so I wouldn't need to specify timeline. While in
case b) I need to specify this new
timeline(recovery_target_timeline=00000009).
Kindly confirm...

trying to put the scenario pictorially:
   
  t0                              t2
  |               t1              |        
  |-------| ------ |---------- timeline: 00000008
                                   |  
                                   |    timeline:00000009
                                   |----------------------|----
                                                                                    t3



TIA,
Satya



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
  

--------------000304030201020107050607--