Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9653B1337B7D for ; Mon, 3 Jan 2011 16:38: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 93899-06 for ; Mon, 3 Jan 2011 20:38:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id D53111337B71 for ; Mon, 3 Jan 2011 16:38:03 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 03 Jan 2011 14:38:01 -0600 Message-Id: <4D21DF440200002500038F6B@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Mon, 03 Jan 2011 14:37:56 -0600 From: "Kevin Grittner" To: "Imre Oolberg" ,"Tom Lane" Cc: "Scott Ribe" , Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal References: <4D2213EB.7090700@auul.pri.ee> <42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com> <22500.1294080152@sss.pgh.pa.us> <22730.1294081008@sss.pgh.pa.us> <4D222E45.2080701@auul.pri.ee> In-Reply-To: <4D222E45.2080701@auul.pri.ee> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.61 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/21 X-Sequence-Number: 36461 Imre Oolberg wrote: > I am starting to think more in the direction what Kevin Grittner > suggested that i miss something in my procedure and instead > following so to say recovery path i am doing something else which > strangely ends up with working database process but actually > misses some data. Did you keep the pg_xlog/archive_status directory and its *.backup files? It sounds like maybe it's not finding the recovery.conf file. Are the permissions right? Do you have spaces or other special characters in the directory path to your cluster data directory? (I notice you didn't use quoting around the path.) Did you delete (or avoid copying) the postmaster.pid file? Making sure to start with an empty log file and/or directory (depending on how you log), what shows up in the log on your recovery attempt? -Kevin