Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 54AD3632D22 for ; Wed, 25 Mar 2009 03:50:13 -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 61441-07 for ; Wed, 25 Mar 2009 03:50:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f217.google.com (mail-bw0-f217.google.com [209.85.218.217]) by mail.postgresql.org (Postfix) with ESMTP id 9D9C663299E for ; Wed, 25 Mar 2009 03:50:06 -0300 (ADT) Received: by bwz17 with SMTP id 17so3920957bwz.19 for ; Tue, 24 Mar 2009 23:50:04 -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=6LhPfQjrUk9bFifibdxzm4bUWDu/m97WVANjjaYHYbc=; b=HCKoB2Ypyi4M9krDl7kwW+gGr7wibTK/Nj6iKPQosijQFAJOsyUqphDZbzv0EPHMTR KPimqZwQuV5k271L5uKElSFk4mVeoKfkJjgRqvq2V7JYyo9cuknXra5LzNlKKzl5ev2y wTKS4owZGsOg1ih+2mJ/1QAJzS6ze0lO5ZVZ4= 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=WhtxPxp97yuxZ62OsGYW/LPhSda7umchYmIAPYWIiwG3U0e8HveBSrdJHVx3Tv7y+y toZ8lAGnxnHGhegk8UdsKqkmbCzxDELdfp8Dqdf+0lPs225jpSLcTqn6ElQlIBcP1caf lLKFPz6jlLO5+dTPeyBkHcj9dJOeUylgKqhqc= MIME-Version: 1.0 Received: by 10.223.108.75 with SMTP id e11mr7829664fap.51.1237963804620; Tue, 24 Mar 2009 23:50:04 -0700 (PDT) In-Reply-To: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> Date: Wed, 25 Mar 2009 07:50:04 +0100 Message-ID: <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> Subject: Re: New trigger option of pg_standby From: Guillaume Smet To: Fujii Masao 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/971 X-Sequence-Number: 135649 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. -- Guillaume