Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 433D763408B for ; Wed, 25 Mar 2009 05:56:02 -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 87662-06 for ; Wed, 25 Mar 2009 05:55:55 -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 8A7A463381E for ; Wed, 25 Mar 2009 05:55:51 -0300 (ADT) Received: by bwz17 with SMTP id 17so3979177bwz.19 for ; Wed, 25 Mar 2009 01:55:49 -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=mA3oHKAErirOv9S49+UVEO5ftj+9/UjdPAHlOEDeeBs=; b=xQYQiQoVbATGe3Sdiu5vSOW9hZA2viP6EZ2piF1fBG/RVZdFrqdX37ebojKGoClByf gEly5goPwGd6z5ngnRvJZD5WqUUelkam44U15X6bGH+tEGbo8AjgrMFzd+jHs/YmvAJY wgq3lXA43An730eVJG28dCb+x39yT+b25jTVI= 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=QgeM9z+jxuqa+bb9X3BxInteTppm/gdoSKY9iVHl8EOdpGsVbhbUFP7+NHDNaa17qO gfSMLp1r6igaAwM5CUmeW9MHJOv8OJchspqZdbeCXd8SXWEJcfpobxSPn1h4SMpVeSVj dALbqow7lvuTmY0rS6iWcHk5aLZLuqOalzfeM= MIME-Version: 1.0 Received: by 10.223.116.205 with SMTP id n13mr7909269faq.103.1237971349128; Wed, 25 Mar 2009 01:55:49 -0700 (PDT) In-Reply-To: <3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> <3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com> Date: Wed, 25 Mar 2009 09:55:49 +0100 Message-ID: <1d4e0c10903250155w34bd79dcvfab2ad5c95e56011@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/974 X-Sequence-Number: 135652 On Wed, Mar 25, 2009 at 9:44 AM, Fujii Masao wrote: > 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. I don't use pg_standby personnaly but I admit I'm quite surprised by the current behaviour. I'm pretty sure a lot of the current users would be surprised too. -- Guillaume