Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3N6b-0007bm-Pm for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Apr 2018 14:40:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f3N6a-0002NO-MZ for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Apr 2018 14:40:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f3N5V-00063O-SN for pgsql-hackers@lists.postgresql.org; Tue, 03 Apr 2018 14:39:06 +0000 Received: from mail-wm0-x241.google.com ([2a00:1450:400c:c09::241]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1f3N5S-0001EZ-2u for pgsql-hackers@postgresql.org; Tue, 03 Apr 2018 14:39:04 +0000 Received: by mail-wm0-x241.google.com with SMTP id o23so16774249wmf.0 for ; Tue, 03 Apr 2018 07:39:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=wVIJ8osxgJ9sCYo+RGxbBV1teOPTNa1ErDLVBAW3lO4=; b=bE/EHMCeugZ6FyA29HIUiLL/y+WHRJ3XgX12KVJ84mm5pTSy9UjijrE8GJvTDmc2zq 9CnwZnmBqH7JZIOoEs27Lz5WhQBjtjyse0oNka1/9Cd1ZCx6YC3q5JsiBslNoaA2orkX C08WqrQFhX+uwjyhJ5YNRfi+x3MnbmV4/iGverjCqttNazwjsJsgpJ3xSCjLXn/PAh+P jR5bgRHyYv7x11GaLIR4cuDsU/6cPZSRe6DFmTRRzaHt1kIiObSfcluhTZt5x4URfX// n27lyfCkLZp9XKxIsnVtQErgREwBejcHsXlzqD04stpVqLigfWP7rbd+U3CPd5UWoHF2 /hdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-language:content-transfer-encoding; bh=wVIJ8osxgJ9sCYo+RGxbBV1teOPTNa1ErDLVBAW3lO4=; b=kw+zgTkPWr+GsjpgN5reVUtB8fd5OopFq+SdK8LSAiCC9JdZN/VSb0e++VkP/afie9 iyRS72jMUjyOHkllIWS84sN7ixQzBT1/LGID2BJp7xzOrH1oq2gOsmpkdhdLckH2GvKb +ts11YHj2Mpv++s8Nq1wXDvDwu8zSfEy5I3OJ6iVNrPjfHumZEfm3eFh5u5UNrW2rXq/ P7ms70a/kyZWmwfgNn+96M6G6QU28rOk856eLyJ/GsBRVM9CPj4fU/NdNH3k90PvXtVt rOmYAwirdw2TXVQ5EVQEj5c0S17Vj251d+KWVinc7b9HKRyUgUG8lrx21RFldhIOqPqp nuEQ== X-Gm-Message-State: AElRT7GoMZ7ellthVEcV1Auf2W46PZVxpol/TRTExdIcpa3uDEf4IHnD cIQwjMBHzvCZxOz/WbZMrov8nw== X-Google-Smtp-Source: AIpwx495NtCFAMMzmHnI2/nPwkllnDP0Z5gEYCql7NEV/cYVLgxdOhK9zNtTpFZw6HPpxnbKmd8/lA== X-Received: by 10.80.205.210 with SMTP id h18mr17165934edj.234.1522766340657; Tue, 03 Apr 2018 07:39:00 -0700 (PDT) Received: from [10.137.2.17] ([212.24.157.174]) by smtp.gmail.com with ESMTPSA id k7sm2032627edb.51.2018.04.03.07.38.59 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 03 Apr 2018 07:38:59 -0700 (PDT) Subject: Re: [HACKERS] logical decoding of two-phase transactions To: Alvaro Herrera Cc: Stas Kelvich , Nikhil Sontakke , Andres Freund , Simon Riggs , Craig Ringer , Peter Eisentraut , Petr Jelinek , Sokolov Yura , Dmitry Dolgov <9erthalion6@gmail.com>, Tom Lane , Masahiko Sawada , PostgreSQL Hackers , Robert Haas References: <20180403143736.z42lxviikrf4iyxc@alvherre.pgsql> From: Tomas Vondra Openpgp: preference=signencrypt Autocrypt: addr=tomas.vondra@2ndquadrant.com; prefer-encrypt=mutual; keydata= xsFNBFSsTToBEADfyqVlb3XsQt4zllL1UTXFr4VVbyuZYggxL9UpMekIUG84wEjrzf+RJVWp WAjrZ6kHt4zomKdylow8/h0ympc7RzMkWtRE+0RGiN3ssfxXB+qqaINEgL71g/bGELq4S15B kZi+H6sEGrVQ2j3yuycWtNRsrzFiUZL92M/rfBduDfZwA42AymDzt9EsErbZvmck3DS7Sjm1 kcsyNRrFeN7hCKrGRRRW5CEWX/45ESd4mTh/jcIXPfS0sWvqRwcaBOHimufW7T5xdhNy83Ed YJxyMcEHPg8FlPSi3PII9vc3ZqQcFv+3/ChxoITjGgmS72jQ1uuKgvWFeYjLxXcyRN552QV1 dK7xclRsvLlKeR3ub9YU1KP4PbZMX+Fd6aZIxwMW25la2wGiyTb2okjsldz9xpGAyUccj0ZN 1w/XX03heRRg2heG3QGA0z0Mo5UuOn8l340zNRKycRGso7bczdyUYm//sLiEwDJMNi2XF65J BDCikt0uGNxZmnjxoi6ECAkATeG5q4SK4uTX7hUomn6a6IBpvoaceNjJ6MNE8uzXuWSYpntf T/e3sF+SIwfzkVdc4ASD7a796sddyUMhr5e/KrG2RMERhMZ9OOkJXWOBFBr+lek1wzNvBGtL aT2S1oEz77eRPxDm8yh46b1d5tEkcXBw7tdNjEhtLOIjBvJj8wARAQABzStUb21hcyBWb25k cmEgPHRvbWFzLnZvbmRyYUAybmRxdWFkcmFudC5jb20+wsF9BBMBCgAnAhsDBQsJCAcDBRUK CQgLBRYCAwEAAh4BAheABQJavO66BQkH8dUAAAoJEHr8T34Q28YxgtsP/3P2IpqIQ+NJ5NwX YU7VTtutZOkUFCDmkuaIR1f9aAUOVXPO225sSB51m686Ro5JFnJVtty9o3eBT3TJwDsf8RKX WoUpye1MToGuRURMCHwyD7DLh+vWz7oMRQRVVbO87Quh5cpz1GGFZ1rh9MmpHJlP6/TzT2gH w8KlOLmIiitvv5nR6uK1lYPQX3wg5HSq0uDEReyEOsDKe7JWqBi2512savPfBJ7SR4917H3n 6vQHId2s4dgaYzlC09csqvRKEB5JFbQ6cGGQ2vLjhlWmii+njXCT3Aiq0GKHYIpl/wiT4PhZ TMd9H8ZitMVAQEJF8BrBLAKth9Ydqs8Yt2SS/FX8Z+NNIIS1PzIzB+c14GilHnP9qgBDeMSe w5gQ51ejiHTt4uqziWEqFEM+2tdDtm53e0BgfM0sAnhtToKpZ588otD8VJ6tapdNGt/JxZN6 9xNFE66BeAEVDwY25L1k7Sd8RDfeTlS9+GvlGmtLACrm41FjDkg+xaWs2MPXXOK0cZFwtFJw 6lZohAswSyfeXtvrsfNFWV3ww9DUsS46IqRkU4pZWonPR+MTxL98RwzhVNO84lcDbXM3WYsZ kmy8pvqdh6pbBHIRV3VmH1D6i9qovttLZWKZeD0FBIIPtUl7hOKyNG+WJXpiFRquJIXW9MSa vwLQd+FGy9PxXfvyAmsJzsFNBFSsTToBEADImGvEViP6kfZktPad6AddDNiSkI0hXnx+EijS 84aAcUdZ0ry16cq4ywH+0aAxcP8JgmYXdk1o1/c4wWuL5GOLvES+3/xuZjy0i6W3akJus0Ne q0kvO8hYP/+omXvjdmF3Wppd+QYYjn1OvH7dzlJWCVoBuvkctpKKDFi79RqAjfGv5CQ3PB0M +w2++3n87nFUt5mW21xsYBOZ1wb5WPzVMSEW2ocGf206kX5zQzWgQksig6Hha9IHC9lcDqIC oJcXhX9mPXfTv3LWFu6+zn1e80Q16p9xQMpGw64JzeCvEyuwBQwdBQvlsmEh/0bXqlr9qF81 4abNn2HAv/abOWOIxb8dgAoariJb9/LnReYndpkhKvPUrWx/GXvZ+iRAH4reaNe55AXTn3vR /dyl2hINFfKzUQ7HiniLjZQ0+I99EhaitB7fXJrkoJDyovs7xTDJV4oa2HBYT40F5wTRQuJ3 2fs5qHH7GyRYASTC9UpkxYhfJJ8RHx/aJCqxx9kaGahk/IVQcBA1QM6x1T4j/Kt45wtqI61e u6fJVIo4+Ety91XMggw28vZWKnsKuamNA0Umt5/r5czlvdJqJaMgdZlURLQfzX6LijqRilUM oRNtegOCsdRp2g9t2imHsbla5CVXHUeBajfy32PQCx1AJhGROv9YdfFv86S++kdUZfktHwAR AQABwsFlBBgBCgAPBQJUrE06AhsMBQkDwmcAAAoJEHr8T34Q28YxoUIP/3m7w4/OKYIHlCUF eqOr9QJ9dLZu45yJZ+OHGGjjSsFEomCcch1O1AyGOGAalCy11eP9d8/pq42DZ4U884LZRDJi AsOC1v7aIbTsHTgNfVZEOfP61Irq6ExHM63yE5SUVM2pGV8BjkDTC+1+Bwnhc6fIOG/V1oEP gDuesd9TnkSYbBXnsFD1XKmmPeQZFbH4FF6bHQnDpBUsHuD1+CpbsbqLHsLrGmsCGKJB2Bfh 0GfuhX7pv6/195YRUNNWdiQEwcvVHn/SaEWholx2ZDIWNDHo6ki+Y/KUYuKJ+iAlWYyj/pU6 dUX56T0QvQlLN9LSAtaDeDltGm7f7JpfrLGqbG4FKC1xJt1crMDonOm8BCgCQjVu5/JV6v+y HsGbydn53gBzz3Kg2Ig4MkO36jU4lhp6rg7tAc1SrrKfwyns5Q3k1hFAp3yaa0epQySG/nZF snXvTYvZ/wAS4S8JK9rclxR7OOmwx3S+6SBptGsN0KY63B8wOqNohAEMitWqrp/aRcKfY6Hm 7bAT5VA0Sl1F2Xwf6ISalG+7iVcc6n9NXByO4QO60KbIHC2131rdpnDwOpGEcRKeUw1h3mvH S072tMtixCvFuiJ22JzAXdLXa1C0gZiZY/usDcY+oJsLIiQyFOl4SU8ACW43dBMdAjZ2Wamg aHGJaAIX4NfWQQwk5FoEwsFlBBgBCgAPAhsMBQJavO7BBQkH8dUHAAoJEHr8T34Q28Yxj6EQ AIXEEsxvnoc6KkE0pMhumwjaOhqk72pAE8dQx0j69NhvlncOynvHSSV41IhjmDvi1i5xMQ/z JNMzjHlzyn4B4xNdv9HNnRl649chWDgrE23r+nGdsF7jbvZ7/75TMKDcypc5B4kwbTsgNr/4 DrhC3Cgp9RSb1bLOrKrArhkStRZiVDplA3b4cv9BhHTV2yz791KXI2u7m0JP+kWBInsG8LTf WTEwHsscZQn4fOpPupz5B79z5ByClILAD4pc51pDqg0jijEXctiYjFsd/nX/ohTNnku0FopX EowzYEsckvyAEItUzIOqtSuM9Y1H/vz90tHM0DzfUl7lnPHo4SQ8MJ9Pjr6SGHtFSUs/aGv+ 7YXUrEUzzFBUjYDhpaX/tRbm7i9FP27w0XD6kyAmUoBMKmajxLlnGW73xeXgtB0NHne3hi5Q 95AhcGRNqz+AFeDOLgOKjhya1JX9790Sv0uMElNDZaqzwHXuemSlZuvxnvqi/eFqr8N8RN0D ly2MMqQ0hzsPSgYHIFBibBW3bmrVfIQXfcFckrfoeQaHeVPgrNMh5A6NdIK2ONQUDvq84FHi 6jMMjGopc4PsbrO5q0/G7/FdX1whaLVx94St3XJ5s6ZGu9CRZDDY/k9hDbimBHHVcChnwjay vYQVbtJ4LvfohZZKzzu7kxGBXFPWgBby2mlK Message-ID: <52ebcc54-9952-79da-64fe-f28f539bec00@2ndquadrant.com> Date: Tue, 3 Apr 2018 16:38:55 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <20180403143736.z42lxviikrf4iyxc@alvherre.pgsql> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 04/03/2018 04:37 PM, Alvaro Herrera wrote: > Tomas Vondra wrote: > >> Yes, that is a good point actually - we need to test that replication >> between PG10 and PG11 works correctly, i.e. that the protocol version is >> correctly negotiated, and features are disabled/enabled accordingly etc. > > Maybe it'd be good to have a buildfarm animal to specifically test for > that? > Not sure a buildfarm supports running two clusters with different versions easily? regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services