Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 616EE6338C8 for ; Tue, 7 Apr 2009 19:01:41 -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 41841-04 for ; Tue, 7 Apr 2009 19:01:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f222.google.com (mail-fx0-f222.google.com [209.85.220.222]) by mail.postgresql.org (Postfix) with ESMTP id 581496337EE for ; Tue, 7 Apr 2009 19:01:39 -0300 (ADT) Received: by fxm22 with SMTP id 22so4589757fxm.19 for ; Tue, 07 Apr 2009 15:01:33 -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=MAHwcTaR9Bqohp2RCZtxlC2H+PdNHI+WenInUlpZ+3g=; b=YycgKUKut5UuPT7oHsYiWOhpKOrb1BaJ/jCW2vbXlk/EKLALNBlDfcsPH1neh08LgK mLe1GMWSlwaXc5nWjb9K0Dnm9xuiyUB8tY62sKu73q4Cc/3Yrlhw14155vHg47wlxU6g ghAAUZsp/KPD4W6qLCmamc+iZFaLmzPD+CWrk= 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=JC0h51w3e7qxAegM4sMi5czufx8kJdZNUVgC5UILrSiKCSewd8MDN7MWas+YC5PkGb N8acXPXh14mfR35Nv5ej9bMRlVK1gSRyJgrHUi6KpPJYtQ2TUz8uSzXtDKrlXj8au0ON zxIVlCllpMkYoHjsVRKtGgt1JGZMClMpwEnE0= MIME-Version: 1.0 Received: by 10.223.122.15 with SMTP id j15mr262028far.10.1239141364872; Tue, 07 Apr 2009 14:56:04 -0700 (PDT) In-Reply-To: <3f0b79eb0904022042g35b8e3cah9432ff764e721a3@mail.gmail.com> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10903250848x4e067c86ue611c0c50f25e49d@mail.gmail.com> <3f0b79eb0903251851v5936d6b4x49997ac8f04b98b9@mail.gmail.com> <1d4e0c10903260032v767da1fdg6cf7cea86c64cc45@mail.gmail.com> <1238064633.16568.420.camel@ebony.2ndQuadrant> <49CCBEE0.1080307@gmx.net> <8365.1238163943@sss.pgh.pa.us> <1238164596.16568.604.camel@ebony.2ndQuadrant> <3f0b79eb0903311901h70520cc8u9c0f1d8f4193923b@mail.gmail.com> <3f0b79eb0904022042g35b8e3cah9432ff764e721a3@mail.gmail.com> Date: Tue, 7 Apr 2009 23:56:04 +0200 Message-ID: <1d4e0c10904071456m735e3f67q123b87243d2f6f2a@mail.gmail.com> Subject: Re: New trigger option of pg_standby From: Guillaume Smet To: Fujii Masao Cc: Simon Riggs , Tom Lane , Peter Eisentraut , Kevin Grittner , 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.155 tagged_above=0 required=5 tests=AWL=0.155 X-Spam-Level: X-Archive-Number: 200904/390 X-Sequence-Number: 136493 On Fri, Apr 3, 2009 at 5:42 AM, Fujii Masao wrote: > Here is the patch; > - Smart failover is chosen if the trigger file labeled "smart" or > an empty one exists. > - Fast failover is chosen if the trigger file labeled "fast" exists, > the signal (SIGUSR1 or SIGINT) is received or the wait timeout > happens. After some further thoughts, +1 for this approach too. I think you imply 'containing "smart"' not 'labeled "smart"'. "Labeled" is confusing IMHO. +1 to change the default behaviour too. All the people discovering the current behaviour are totally surprised. -- Guillaume