Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 24973633C30 for ; Fri, 2 Oct 2009 12:04:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76141-07 for ; Fri, 2 Oct 2009 15:04:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og123.obsmtp.com (exprod7og123.obsmtp.com [64.18.2.24]) by mail.postgresql.org (Postfix) with SMTP id 60C3D63368B for ; Fri, 2 Oct 2009 12:04:17 -0300 (ADT) Received: from source ([209.85.219.224]) by exprod7ob123.postini.com ([64.18.6.12]) with SMTP ID DSNKSsYWbi72nMMp5UwN2JReo2yCtFs0fT1V@postini.com; Fri, 02 Oct 2009 08:04:17 PDT Received: by ewy24 with SMTP id 24so1019647ewy.46 for ; Fri, 02 Oct 2009 08:04:14 -0700 (PDT) Received: by 10.210.160.10 with SMTP id i10mr9782897ebe.10.1254495854130; Fri, 02 Oct 2009 08:04:14 -0700 (PDT) Received: from ?192.168.1.117? ([88.195.103.165]) by mx.google.com with ESMTPS id 7sm44937eyg.27.2009.10.02.08.04.12 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 02 Oct 2009 08:04:12 -0700 (PDT) Message-ID: <4AC6166A.1070501@enterprisedb.com> Date: Fri, 02 Oct 2009 18:04:10 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Simon Riggs CC: pgsql-hackers Subject: Re: Hot Standby on git References: <1253958559.4449.833.camel@ebony.2ndQuadrant> <4AC2FBB9.7060304@enterprisedb.com> <1254408330.17864.233.camel@ebony.2ndQuadrant> <4AC4CF18.50309@enterprisedb.com> <1254413624.17864.243.camel@ebony.2ndQuadrant> <4AC5A60F.5050503@enterprisedb.com> <1254468966.17864.301.camel@ebony.2ndQuadrant> <4AC5AF36.3020900@enterprisedb.com> <1254470874.17864.309.camel@ebony.2ndQuadrant> <4AC5B92A.7090508@enterprisedb.com> <1254480411.17864.368.camel@ebony.2ndQuadrant> <4AC5DB71.7000105@enterprisedb.com> <1254487247.17864.377.camel@ebony.2ndQuadrant> In-Reply-To: <1254487247.17864.377.camel@ebony.2ndQuadrant> 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=-6.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599, RCVD_IN_DNSWL_MED=-4 X-Spam-Level: X-Archive-Number: 200910/164 X-Sequence-Number: 146976 Simon Riggs wrote: > I will add code to make a shutdown checkpoint be a valid starting place > for Hot Standby, as long as there are no in-doubt prepared transactions. > That way we know there are no xids still running and no locks, without > needing to write a record to say so. Ok, I can live with that, and should be dead simple to implement. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com