Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id B1799632D40 for ; Tue, 21 Apr 2009 08:28:31 -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 38784-02 for ; Tue, 21 Apr 2009 08:28:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og120.obsmtp.com (exprod7og120.obsmtp.com [64.18.2.18]) by mail.postgresql.org (Postfix) with SMTP id 5295262FBB4 for ; Tue, 21 Apr 2009 08:28:28 -0300 (ADT) Received: from source ([209.85.219.176]) by exprod7ob120.postini.com ([64.18.6.12]) with SMTP ID DSNKSe2t2rl51UXHZf3h4rODYesndimDibBj@postini.com; Tue, 21 Apr 2009 04:28:28 PDT Received: by ewy24 with SMTP id 24so1537175ewy.37 for ; Tue, 21 Apr 2009 04:28:25 -0700 (PDT) Received: by 10.210.82.2 with SMTP id f2mr2994369ebb.4.1240313305443; Tue, 21 Apr 2009 04:28:25 -0700 (PDT) Received: from ?80.223.212.7? (dsl-hkibrasgw2-fed4df00-7.dhcp.inet.fi [80.223.212.7]) by mx.google.com with ESMTPS id 7sm3613224eyg.54.2009.04.21.04.28.24 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 21 Apr 2009 04:28:24 -0700 (PDT) Message-ID: <49EDADD6.1090006@enterprisedb.com> Date: Tue, 21 Apr 2009 14:28:22 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103) MIME-Version: 1.0 To: Simon Riggs CC: Fujii Masao , Guillaume Smet , Tom Lane , Peter Eisentraut , Kevin Grittner , pgsql-hackers Subject: Re: New trigger option of pg_standby References: <3f0b79eb0903242329j12865d55s348f5c873a956e71@mail.gmail.com> <1d4e0c10904071456m735e3f67q123b87243d2f6f2a@mail.gmail.com> <3f0b79eb0904071817u5c32254ei61f7e68e54669d9e@mail.gmail.com> <49DDEE72.6030803@enterprisedb.com> <3f0b79eb0904092047w355e0b3ar527a9285b161ef91@mail.gmail.com> <1239381103.16396.30.camel@ebony.2ndQuadrant> <3f0b79eb0904122252t1f4c5860v919d199f399ccf72@mail.gmail.com> <3f0b79eb0904132241p18084914g792cb8e5ab3eebb3@mail.gmail.com> <3f0b79eb0904150101pb1c59a3ubb422867e8e6a944@mail.gmail.com> <49EC3B01.6050509@enterprisedb.com> <3f0b79eb0904200354u41b54017u16dc73d021c03cdb@mail.gmail.com> <49EC8B06.3020204@enterprisedb.com> <1240311836.23905.206.camel@ebony.fara.com> <49EDAB5B.5040400@enterprisedb.com> <1240313150.23905.222.camel@ebony.fara.com> In-Reply-To: <1240313150.23905.222.camel@ebony.fara.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200904/1067 X-Sequence-Number: 137170 Simon Riggs wrote: > If you do this, then you would have to change the procedure written into > the 8.3 docs also. Docs aren't backpatchable. > > What you propose is *better* than raw pg_standby is now, but still not > enough in all cases, as I think you know. No, I don't. What is the case where it doesn't work? > Simple isn't the requirement here, is it? Simplicity is always a virtue, because it leads to maintainability. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com