Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7yZQ-0005qT-7B for pgsql-admin@arkaria.postgresql.org; Sat, 10 Aug 2013 02:06:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V7yZP-0001ct-HS for pgsql-admin@arkaria.postgresql.org; Sat, 10 Aug 2013 02:06:19 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7yZO-0001cm-AJ for pgsql-admin@postgresql.org; Sat, 10 Aug 2013 02:06:18 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V7yZL-00023h-Fo for pgsql-admin@postgresql.org; Sat, 10 Aug 2013 02:06:17 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1V7yZK-0005nj-54; Fri, 09 Aug 2013 22:06:14 -0400 Date: Fri, 9 Aug 2013 22:06:14 -0400 From: Bruce Momjian To: Jan Lentfer Cc: pgsql-admin@postgresql.org Subject: Re: Clarification when using Continous Archiving in 8.4 Message-ID: <20130810020614.GE30558@momjian.us> References: <51E5753E.5030001@tiendalinux.com> <20130809013635.GE6883@momjian.us> <1c119d4eb4d3ed11072d3d21ebae2f5c@neslonek.homeunix.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1c119d4eb4d3ed11072d3d21ebae2f5c@neslonek.homeunix.org> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -0.5 (/) 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 On Fri, Aug 9, 2013 at 10:20:13AM +0200, Jan Lentfer wrote: > 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 EnterpriseDB http://enterprisedb.com + 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 Yes, that is the right information. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin