Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7i00-0007i2-3T for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 08:24:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V7hzz-0003fq-Jf for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 08:24:39 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7hzy-0003fk-OJ for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 08:24:38 +0000 Received: from mout2.freenet.de ([2001:748:100:40::2:4]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7hzv-0008R7-Qj for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 08:24:38 +0000 Received: from [195.4.92.142] (helo=mjail2.freenet.de) by mout2.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (port 25) (Exim 4.80.1 #4) id 1V7hzs-0001NN-Jt for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 10:24:32 +0200 Received: from localhost ([::1]:57195 helo=mjail2.freenet.de) by mjail2.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (Exim 4.80.1 #4) id 1V7hzs-0006T4-Dd for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 10:24:32 +0200 Received: from mx3.freenet.de ([195.4.92.13]:46447) by mjail2.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (Exim 4.80.1 #4) id 1V7hx8-0003i1-U8 for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 10:21:42 +0200 Received: from p57981cb5.dip0.t-ipconnect.de ([87.152.28.181]:1216 helo=epia.lan.net) by mx3.freenet.de with esmtpa (ID jan.lentfer@freenet.de) (port 25) (Exim 4.80.1 #4) id 1V7hx8-0005Vc-BH for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 10:21:42 +0200 Received: from localhost (localhost [127.0.0.1]) by epia.lan.net (Postfix) with ESMTP id 4561A40C4D816 for ; Fri, 9 Aug 2013 10:21:41 +0200 (CEST) X-Virus-Scanned: amavisd-new at lan.net Received: from epia.lan.net ([127.0.0.1]) by localhost (epia.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id GyewhUwP_IK3 for ; Fri, 9 Aug 2013 10:20:50 +0200 (CEST) Received: from neslonek.homeunix.org (localhost [127.0.0.1]) by epia.lan.net (Postfix) with ESMTP id B6E3E40C4DB1D for ; Fri, 9 Aug 2013 10:20:16 +0200 (CEST) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_9839c3551044c88d4da69b221809d73a" Date: Fri, 09 Aug 2013 10:20:13 +0200 From: Jan Lentfer To: Subject: Re: Clarification when using Continous Archiving in 8.4 In-Reply-To: <20130809013635.GE6883@momjian.us> References: <51E5753E.5030001@tiendalinux.com> <20130809013635.GE6883@momjian.us> Message-ID: <1c119d4eb4d3ed11072d3d21ebae2f5c@neslonek.homeunix.org> X-Sender: Jan.Lentfer@web.de User-Agent: RoundCube Webmail/0.5.3 X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --=_9839c3551044c88d4da69b221809d73a Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=UTF-8 On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote: > On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote: > >> Hello People, In reference to my last post , my question is: It is possible to recover more (subsequent) WAL files when I have already recover a postgres 8.4 database using a PITR ? I have read on some places that it's not possible and I want to confirm that, is it possible in 9.1 ? > > I am confused. You did recovery, and then you want to do more WAL > files past your stop point? > > -- Bruce Momjian http://momjian.us [2] EnterpriseDB http://enterprisedb.com [3] + It's impossible for everything to be true. + With 8.4 (up to 9.0) you have to restart the PITR over and over again, if you "missed" the desired point. Starting with 9.1 there is pause_at_recovery_target(). Is that what you mean? http://www.postgresql.org/docs/9.1/interactive/recovery-target-settings.html Regards Jan -- professional: http://www.oscar-consult.de private: http://neslonek.homeunix.org/drupal/ Links: ------ [1] mailto:bruce@momjian.us [2] http://momjian.us [3] http://enterprisedb.com --=_9839c3551044c88d4da69b221809d73a Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=UTF-8

On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote:

On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote:
Hello People, In reference to my last= post , my question is: It is possible to recover more (subsequent) WAL fil= es when I have already recover a postgres 8.4 database using a PITR ? I hav= e read on some places that it's not possible and I want to confirm that, is= it possible in 9.1 ?
I am confused.   You did recovery, and then you want to do more WAL
files past your stop point?

-- Bruce Momjian <bruce@momjian.us> http://momjian.us<=
/a> EnterpriseDB http://enterprisedb.co=
m + It's impossible for everything to be true. + 

With 8.4 (up to 9.0) you have to restart the PITR over and over again, i= f you "missed" the desired point. Starting with 9.1 there is pause_at_recovery_target(). Is that what you mean?

http://www.postgresql.org/docs/9.1/interactive/recovery-target-settings= =2Ehtml

Regards

 

Jan

--=20
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/
--=_9839c3551044c88d4da69b221809d73a--