Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5995163517C for ; Wed, 25 Mar 2009 05:45:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 85889-01-4 for ; Wed, 25 Mar 2009 05:44:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.234]) by mail.postgresql.org (Postfix) with ESMTP id 450CC634C42 for ; Wed, 25 Mar 2009 05:44:55 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id l9so3029118rvb.43 for ; Wed, 25 Mar 2009 01:44:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=IQZB/0jo19il2bsg4ExWeK1IlNIQA0uio35yv1O3C+Q=; b=tf9VseDhLDwroQVzFaomx1g3fGXgvkJBTiaF5NsGKP1C7l/oy0Ioxf5yThabmFa7SX rZ0QXoF9/2XbGkH4Sh9lyrBtWcfJyUdiv/KBACdzFBBJRgzvHVwxbuKGN34Sd0secqfs uOb7MnmcOIM808kTzii6vRSd9vkflEmVoNnck= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=hl5tHEmKi2L7cPSkS1S/32oRYb8ptNB7XwqLdKNydwP/AawOXfIjpdFD0trOPXoTG+ CWE0rcTBCGF4Y2Vjv/vYt8h0mJptNlaQYJeR0kn6xRYsYX23zrbP8NpzVitP1DN0rkKX +uOjHmsIWEOdhAzc8woDX26YIXW40CvqySq3o= MIME-Version: 1.0 Received: by 10.140.207.18 with SMTP id e18mr3461094rvg.4.1237970692835; Wed, 25 Mar 2009 01:44:52 -0700 (PDT) In-Reply-To: <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> Date: Wed, 25 Mar 2009 17:44:52 +0900 Message-ID: <3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com> Subject: Re: New trigger option of pg_standby From: Fujii Masao To: guillaume.smet@gmail.com Cc: pgsql-hackers Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/973 X-Sequence-Number: 135651 Hi, Thanks for the comment. On Wed, Mar 25, 2009 at 3:50 PM, Guillaume Smet wrote: > On Wed, Mar 25, 2009 at 7:29 AM, Fujii Masao wrote: >> Attached patch fixes the above problem by adding a new trigger option >> to pg_standby; the presence of this new trigger file causes recovery to >> end after replaying all the available WAL files. > > Shouldn't it be the default? It seems like the most expected behaviour to me. Yeah, I agree... but there may be scripts for warm-standby based on the existing default behavior. So, I didn't make a new trigger the default. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center