X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 86C20D1B1BE for ; Thu, 22 Jul 2004 20:08:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99547-08 for ; Thu, 22 Jul 2004 23:08:18 +0000 (GMT) Received: from mail.coretech.co.nz (coretech.co.nz [202.36.204.41]) by svr1.postgresql.org (Postfix) with ESMTP id 2309ED1B262 for ; Thu, 22 Jul 2004 20:08:14 -0300 (ADT) Received: (qmail 26836 invoked from network); 22 Jul 2004 23:08:11 -0000 Received: from unknown (HELO coretech.co.nz) (10.0.10.28) by 0 with SMTP; 22 Jul 2004 23:08:11 -0000 Message-ID: <410048D9.8020707@coretech.co.nz> Date: Fri, 23 Jul 2004 11:08:09 +1200 From: Mark Kirkwood User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Simon Riggs , pgsql-admin@postgresql.org Subject: Re: [HACKERS] Point in Time Recovery References: <200407132242.i6DMgg612564@candle.pha.pa.us> <1089760416.17493.3327.camel@stromboli> <40F49AE9.2060805@familyhealth.com.au> <1089789682.17493.3890.camel@stromboli> <40FF1D88.30404@coretech.co.nz> <12173.1090527593@sss.pgh.pa.us> In-Reply-To: <12173.1090527593@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/258 X-Sequence-Number: 14326 Excellent - Just updated and it is all good! This change makes the whole "how do I do my backup" business nice and basic - which the right way IMHO. regards Mark Tom Lane wrote: >Mark Kirkwood writes: > > >>2) Is is possible to make the recovery kick in even though pg_control >>says the database state is shutdown? >> >> > >Yeah, I think you are right: presence of recovery.conf should force a >WAL scan even if pg_control claims it's shut down. Fix committed. > > regards, tom lane > >