Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id BC7D42E0058 for ; Mon, 12 May 2008 22:07:01 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67969-02-2 for ; Mon, 12 May 2008 22:06:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by developer.postgresql.org (Postfix) with ESMTP id 982DC2E0068 for ; Mon, 12 May 2008 22:06:32 -0300 (ADT) Received: from ridley.home ([72.81.136.83]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K0S00HY38ESHB34@vms042.mailsrvcs.net> for pgsql-hackers@postgresql.org; Mon, 12 May 2008 20:06:29 -0500 (CDT) Date: Mon, 12 May 2008 21:06:26 -0400 From: Robert Treat Subject: Re: odd output in restore mode In-reply-to: <4828CB9D.7070102@dunslane.net> To: pgsql-hackers@postgresql.org Cc: Andrew Dunstan , Simon Riggs Message-id: <200805122106.27351.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <4828AF1D.7060405@dunslane.net> <1210630440.29684.249.camel@ebony.site> <4828CB9D.7070102@dunslane.net> User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/390 X-Sequence-Number: 118389 On Monday 12 May 2008 18:58:37 Andrew Dunstan wrote: > Simon Riggs wrote: > >> Lastly, not quite related to this output, but in the same general area, > >> should we have an option on pg_standby to allow removing the archive > >> file after it has been restored? > > > > There already is one, but its more complex than that. (%r) > > I was using %r. But the WAL files that have been restored (according to > the log) are still in the archive dir. So it looks like %r isn't working > properly. > Are you sure you've moved passed the latest restart point? Just because a WAL file has been processed doesn't mean it can be deleted. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL