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 14F06DAE87 for ; Tue, 25 Oct 2005 17:35:00 -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 13327-10 for ; Tue, 25 Oct 2005 20:34:57 +0000 (GMT) Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id 7C244DAE83 for ; Tue, 25 Oct 2005 17:34:56 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 25 Oct 2005 17:34:18 -0300 X-IronPort-AV: i="3.97,250,1125892800"; d="scan'208"; a="20545586:sNHT238218072" Received: from alvh.no-ip.org (200.85.220.75) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4350159700158BC1; Tue, 25 Oct 2005 17:34:58 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 80640C2D469; Tue, 25 Oct 2005 17:35:35 -0300 (CLST) Date: Tue, 25 Oct 2005 17:35:35 -0300 From: Alvaro Herrera To: Jeff Frost Cc: Tom Lane , pgsql-admin@postgresql.org Subject: Re: files to ignore during pitr base backup Message-ID: <20051025203535.GC7836@surnet.cl> Mail-Followup-To: Jeff Frost , Tom Lane , pgsql-admin@postgresql.org References: <18695.1130263765@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.06 required=5 tests=[AWL=-0.716, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200510/268 X-Sequence-Number: 19340 Jeff Frost wrote: > On Tue, 25 Oct 2005, Tom Lane wrote: > > >It's safe to exclude those, but those are hardly the only files that > >might "disappear" in a live database. It'd be better to use a dump > >tool that's less picky about the source data changing under it. We've > >had similar reports about GNU tar being too smart for this purpose :-( > > I would have thought that the pg_start_backup() function would tell the > postmasters not to take files out from under the base backup process? That would be impossible unless you wanted backends to freeze from time to time while you take the base backup. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "La rebeldía es la virtud original del hombre" (Arthur Schopenhauer)