From q16414@motorola.com Thu Jul 13 15:20:38 2006 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-- From sptripathi78@yahoo.com Thu Jul 13 15:16:50 2006 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 0253C9FB1D2 for ; Thu, 13 Jul 2006 12:16:50 -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 08676-02 for ; Thu, 13 Jul 2006 12:16:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web52012.mail.yahoo.com (web52012.mail.yahoo.com [206.190.48.95]) by postgresql.org (Postfix) with SMTP id 98F369FB1D8 for ; Thu, 13 Jul 2006 12:16:41 -0300 (ADT) Received: (qmail 55610 invoked by uid 60001); 13 Jul 2006 15:16:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JmLtK9Z4ZrYbX4lTQlrqeP25Z8N15W2Xfu7LxSowflIeR4yMW2Rzr4dqXOZOrLmn/tF4Ff0JgWMTTstSBQZOoJWy9+UISsOeRglLmrvlCWKkDzkwbOKJ7KBz05q4uEOtlwpnwYGu46pxuRq6qhrGuUwofkw5pvl9yzq4YPiLslA= ; Message-ID: <20060713151636.55608.qmail@web52012.mail.yahoo.com> Received: from [203.126.136.220] by web52012.mail.yahoo.com via HTTP; Thu, 13 Jul 2006 08:16:36 PDT Date: Thu, 13 Jul 2006 08:16:36 -0700 (PDT) From: Satya Prakash Tripathi Subject: PITR- timeline query To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/97 X-Sequence-Number: 22343 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; Tue, 18 Jul 2006 08:01:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 09488-04-4 for ; Tue, 18 Jul 2006 11:00:21 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web52002.mail.yahoo.com (web52002.mail.yahoo.com [206.190.48.85]) by postgresql.org (Postfix) with SMTP id C31BF9FA4A7 for ; Tue, 18 Jul 2006 07:50:28 -0300 (ADT) Received: (qmail 60317 invoked by uid 60001); 18 Jul 2006 10:50:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zlFDl8F9yxmdS84IaBnQmIaRcbYt7PMH3IGS88+yJfPo08DB8TLgY2UhQTYmn5tP7Xa8Bcd9zJ4zAVwnl5ECsvw9qR3bh6COMeRoemYg/FMrPyOeOgSWscpnNkNnwPj8UlJOnq5glElczU008gsy2o7WouxWSX4DAy6zrCEmczM= ; Message-ID: <20060718105027.60315.qmail@web52002.mail.yahoo.com> Received: from [203.126.136.220] by web52002.mail.yahoo.com via HTTP; Tue, 18 Jul 2006 03:50:26 PDT Date: Tue, 18 Jul 2006 03:50:26 -0700 (PDT) From: Satya Prakash Tripathi Subject: Re: PITR- timeline query To: pgsql-admin@postgresql.org In-Reply-To: <20060713151636.55608.qmail@web52012.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.276 tagged_above=0 required=5 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: X-Archive-Number: 200607/152 X-Sequence-Number: 22398 Can anyone answer please ? --- Satya Prakash Tripathi wrote: > 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 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com