Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 860B86335D4 for ; Wed, 25 Mar 2009 12:48:21 -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 95226-06 for ; Wed, 25 Mar 2009 12:48:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f169.google.com (mail-bw0-f169.google.com [209.85.218.169]) by mail.postgresql.org (Postfix) with ESMTP id ACCE2633350 for ; Wed, 25 Mar 2009 12:48:16 -0300 (ADT) Received: by bwz17 with SMTP id 17so133561bwz.19 for ; Wed, 25 Mar 2009 08:48:15 -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=Yh3hDpvpJhj9R24hwr4GD5duWxypc+joWuz45JbspFY=; b=lFhvMRWarFRQdqy1FOGfjjgGWKvjBsxDCW8dYT+h3RyPiw5TRyhJus0CntlvmMmUO1 6BAcWLc7sTUZNRkuMVGkbxxIswtCzBs/dg3pyxrsUFvv+BeH/wE+kaftXa1fpAu9Jjkn eN5fHqHGNY4Ce7n5PdmusyZpP6pb3mGCw5Ue0= 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=S/S8tOc+b2dzD66nmEqlMpiDxY6VTcVTHnDBA7czmcUIX+9jvN7E6/jfzygB8e6U6Q JWcpCs/+16RccFte02KA6TDeBepOT8w77mA9kaAH+D/hwzpuXc7ujRwUS8i6ipINvGHg oMjMtholiLZNqIgmVTJxDp7IEyEEpIMx6Xvcw= MIME-Version: 1.0 Received: by 10.223.119.84 with SMTP id y20mr8319006faq.14.1237996094836; Wed, 25 Mar 2009 08:48:14 -0700 (PDT) In-Reply-To: <49C9F255.EE98.0025.0@wicourts.gov> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> <3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com> <1d4e0c10903250155w34bd79dcvfab2ad5c95e56011@mail.gmail.com> <49C9F255.EE98.0025.0@wicourts.gov> Date: Wed, 25 Mar 2009 16:48:14 +0100 Message-ID: <1d4e0c10903250848x4e067c86ue611c0c50f25e49d@mail.gmail.com> Subject: Re: New trigger option of pg_standby From: Guillaume Smet To: Kevin Grittner Cc: Fujii Masao , 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.032 tagged_above=0 required=5 tests=AWL=0.032 X-Spam-Level: X-Archive-Number: 200903/993 X-Sequence-Number: 135671 On Wed, Mar 25, 2009 at 2:59 PM, Kevin Grittner wrote: > I find it hard to imagine a use case for the existing default > behavior. I thought a bit about it and I think it can be useful when your priority is the availability of the service and you don't consider a data loss that important: even if you have a lot of WALs segments to replay, you may want to have your service up immediately in case of a major problem. Keeping it is a good idea IMHO but I don't think it should be the default. -- Guillaume