Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1F921633957 for ; Fri, 27 Mar 2009 09:03:09 -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 45254-10 for ; Fri, 27 Mar 2009 09:02:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128083.authsmtp.net (outmail128083.authsmtp.net [62.13.128.83]) by mail.postgresql.org (Postfix) with ESMTP id DA578632388 for ; Fri, 27 Mar 2009 09:02:54 -0300 (ADT) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt4.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2RC2mGN005174; Fri, 27 Mar 2009 12:02:48 GMT Received: from [192.168.0.4] (85-211-223-92.dyn.gotadsl.co.uk [85.211.223.92]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2RC2lLe023418; Fri, 27 Mar 2009 12:02:47 GMT Subject: Re: New trigger option of pg_standby From: Simon Riggs To: Peter Eisentraut Cc: Guillaume Smet , Fujii Masao , Kevin Grittner , pgsql-hackers In-Reply-To: <49CCBEE0.1080307@gmx.net> References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10903242350i505a9f6bsa7ba347dc02f90b6@mail.gmail.com> <3f0b79eb0903250144k453b3927mffa8b08678ed057b@mail.gmail.com> <1d4e0c10903250155w34bd79dcvfab2ad5c95e56011@mail.gmail.com> <49C9F255.EE98.0025.0@wicourts.gov> <1d4e0c10903250848x4e067c86ue611c0c50f25e49d@mail.gmail.com> <3f0b79eb0903251851v5936d6b4x49997ac8f04b98b9@mail.gmail.com> <1d4e0c10903260032v767da1fdg6cf7cea86c64cc45@mail.gmail.com> <1238064633.16568.420.camel@ebony.2ndQuadrant> <49CCBEE0.1080307@gmx.net> Content-Type: text/plain Date: Fri, 27 Mar 2009 12:03:25 +0000 Message-Id: <1238155405.16568.593.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 30499748-1ac7-11de-bc7b-001f29070be2 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksacxtFagJbYFhD HGQLW11EUV97WWF/ bw0fZQBDYEtPQQdo U1ZAQE1QEQdtHhxP WBx8IRsuC1BGen10 ZE4sX3VfXAp5dUJ0 S0lQHXAHNDRndWEe BBVFJVBTIh5Kfh4T aFl/U3NfNGdJBC9q VzwTFhsSEA9kHWxz Tx5FMUgTTkkGBHY7 XwwDGjNnGkNNXyoE NAAvLFIWDS42 X-Authentic-SMTP: 61633235383639.kestrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/1129 X-Sequence-Number: 135807 On Fri, 2009-03-27 at 13:56 +0200, Peter Eisentraut wrote: > Simon Riggs wrote: > > If we go with this, I would suggest we make *neither* the default by > > removing -t, and adopting two new options: something like -f == fast > > failover, -p == patient failover. > > -m smart|fast|immediate :-) Yes, a better suggestion. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support