Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 188E61336971 for ; Mon, 3 Jan 2011 14:49:51 -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 76833-04 for ; Mon, 3 Jan 2011 18:49:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.sea5.speakeasy.net (mail1.sea5.speakeasy.net [69.17.117.39]) by mail.postgresql.org (Postfix) with ESMTP id 6173513364DE for ; Mon, 3 Jan 2011 14:49:39 -0400 (AST) Received: (qmail 15529 invoked from network); 3 Jan 2011 18:49:38 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (scott_ribe@killerbytes.com@[72.42.76.25]) (envelope-sender ) by mail1.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 3 Jan 2011 18:49:38 -0000 Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: <22500.1294080152@sss.pgh.pa.us> Date: Mon, 3 Jan 2011 11:49:37 -0700 Cc: Imre Oolberg , pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <4D2213EB.7090700@auul.pri.ee> <42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com> <22500.1294080152@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.1081) 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/17 X-Sequence-Number: 36457 On Jan 3, 2011, at 11:42 AM, Tom Lane wrote: > That's either incorrect or poorly worded. Let's go with poorly worded then. (Actually I don't do this, I use = streaming replication, where I don't have to copy the WAL files because = the standby picks up the ones that are needed.) Unless I misread his earlier post, he is starting the backup, copying = files, stopping the backup, and expecting those transactions (between = start & stop) to be applied, even though files changed during that time = (including WAL files) have not all been copied. Again, unless I misread = his earlier post, he is *not* copying WAL that was generated between = start & stop. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice