Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 23CF11337B9E for ; Fri, 28 Jan 2011 12:46:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 81050-01 for ; Fri, 28 Jan 2011 16:46:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id 9BD1A1337BA1 for ; Fri, 28 Jan 2011 12:46:02 -0400 (AST) Received: from 89-158-241-48.rev.dartybox.com ([89.158.241.48] helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1PirSS-0004hc-F4; Fri, 28 Jan 2011 17:46:00 +0100 Received: by DimIMac.local (Postfix, from userid 501) id 76E83185DA76; Fri, 28 Jan 2011 17:45:53 +0100 (CET) From: Dimitri Fontaine To: "Kevin Grittner" Cc: "Dimitri Fontaine" , "Colin Wilson" , "pgsql-admin\@postgresql.org" Subject: Re: Warm Standby looking for already applied log files Organization: 2ndQuadrant References: <4D3D5C520200002500039B11@gw.wicourts.gov> <4D3D5C520200002500039B11@gw.wicourts.gov> <4D4294170200002500039F5A@gw.wicourts.gov> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Fri, 28 Jan 2011 17:45:53 +0100 In-Reply-To: <4D4294170200002500039F5A@gw.wicourts.gov> (Kevin Grittner's message of "Fri, 28 Jan 2011 10:01:59 -0600") Message-ID: User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/187 X-Sequence-Number: 36627 "Kevin Grittner" writes: > I don't suppose there's something which looks *into* a backup file > and deletes all WAL files not needed to restore the related base > backup? That would eliminate an even *uglier* bash script here. Well with some luck Magnus will be able to complete pg_basebackup in 9.1 so that it's able to include all necessary WAL files, and just them=E2=80=A6 I could have missed it but I didn't read about any effort towards shipping a base backup cleaning tool in 9.1, or even after that. Regards, --=20 Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support