X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E996052BD7 for ; Fri, 19 Aug 2005 00:13:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44708-03 for ; Fri, 19 Aug 2005 03:13:12 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 74BAA52B83 for ; Fri, 19 Aug 2005 00:13:10 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA01DCA7DB; Thu, 18 Aug 2005 23:11:57 -0400 Received: from smtp2.surnet.cl (mr2.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Fri, 19 Aug 2005 03:11:57 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp2.surnet.cl (7.0.031.3) id 4259ADE30120F7C7; Thu, 18 Aug 2005 23:11:57 -0400 Received: from alvh.no-ip.org (200.85.218.40) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60008A07D4; Thu, 18 Aug 2005 23:12:52 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id C5488C2DC2A; Thu, 18 Aug 2005 23:13:39 -0400 (CLT) Date: Thu, 18 Aug 2005 23:13:39 -0400 From: Alvaro Herrera To: Bruce Momjian Cc: Enzo D'addario , pgsql-admin@postgresql.org Subject: Re: On-line backup and point-in-time recovery (PITR) Message-ID: <20050819031339.GA10533@surnet.cl> Mail-Followup-To: Bruce Momjian , Enzo D'addario , pgsql-admin@postgresql.org References: <1124418842.3492.34.camel@tuppy.pienetworks.com> <200508190301.j7J31Ru16769@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200508190301.j7J31Ru16769@candle.pha.pa.us> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.921 required=5 tests=[AWL=-0.905, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, FORGED_RCVD_HELO=0.05, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: * X-Archive-Number: 200508/243 X-Sequence-Number: 18562 On Thu, Aug 18, 2005 at 11:01:27PM -0400, Bruce Momjian wrote: > Enzo D'addario wrote: > > 2.What happens with any DB inserts, updates, deletes etc that occur > > between the SELECT pg_start_backup() and the end of the tar? > > They would be already logged in the WAL files and already applied in the > > tarball, do they then get duplicated during log replay in the recover > > process? > > No, the recovery is just like crash recovery and everything comes back > clean, but you do have to recover to a time _after_ the end of the > backup. If you want to recover to a time during the backup you have to > use the previous backup and xlog files. One important detail is that the system is able to detect whether a change registered in WAL was already applied to the data files or not. So if it's already applied, it doesn't need to be applied again. -- Alvaro Herrera () "La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"