Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B85941337B88 for ; Thu, 30 Dec 2010 11:10:58 -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 70044-01 for ; Thu, 30 Dec 2010 15:10:51 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail6.sea5.speakeasy.net (mail6.sea5.speakeasy.net [69.17.117.50]) by mail.postgresql.org (Postfix) with ESMTP id 40C641337B8A for ; Thu, 30 Dec 2010 11:10:50 -0400 (AST) Received: (qmail 32144 invoked from network); 30 Dec 2010 15:10:50 -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 mail6.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 30 Dec 2010 15:10:50 -0000 Subject: 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: <4D1C670E.1090408@auul.pri.ee> Date: Thu, 30 Dec 2010 08:10:49 -0700 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <153FCB4B-D8B3-4011-B7A6-144CFC441AF5@elevated-dev.com> References: <4D1C670E.1090408@auul.pri.ee> To: Imre Oolberg 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 X-Spam-Level: X-Archive-Number: 201012/208 X-Sequence-Number: 36437 On Dec 30, 2010, at 4:03 AM, Imre Oolberg wrote: > 3. issued pg_start_backup('test') while script is still running Well, yeah. Your procedure is going to get you a consistent snapshot of = the state of the database when you issued that command. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice