Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krxBw-0005Hf-CF for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Dec 2020 06:00:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krxBv-0000LW-2H for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Dec 2020 06:00:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krxBu-0000KF-Q3 for pgsql-bugs@lists.postgresql.org; Wed, 23 Dec 2020 06:00:06 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1krxBr-00014b-De for pgsql-bugs@lists.postgresql.org; Wed, 23 Dec 2020 06:00:06 +0000 Received: by mail-lf1-x12e.google.com with SMTP id m12so37487573lfo.7 for ; Tue, 22 Dec 2020 22:00:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=BvTTWspS0uLUMPnzupqT3wwtxgmzjTe4yi0hH2mhpKA=; b=rzPVY89qd7gP/Lon17PapysGnS3fW7wbfgZ93eZX8fEwHOzDR/yqMLLBkP2zG8xaOo +CjsdQbMGaI2IGGxUQm8Wh3FXnMxNURXnkaut3m0hKqbEoyjIxNK29C8w4fv09zlgC8q JeWu5C+PEhasSeMzH9kyEGvjgO9kpDZttLMmxLfjd460s4eq3Ic5P2l80nJZs1uZScjd EmYDpEED5b+I+Y25d2AjWZPseR8d6ZNGV9SxOLA8QVpjmeqhqMAO95DdaygIOXxQJAFD GgVHNQ6r6whyZABUgpoL23RwVnoHsiNfmWTD98xuPlUSKHh81IMOb6a533qNs+yEH4pK ruwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=BvTTWspS0uLUMPnzupqT3wwtxgmzjTe4yi0hH2mhpKA=; b=p+9PrmR8pejQmJ/x8sTr46kpUXrKiqSZnJac3B7aqCtVctWQy9jEx4Nr2pzSvIy2ru gkZAIcT84PzkLjuPmoFvk1jtxXFg2JQSN4V/EarvjyVte8CfMoTAJEyxRrc1RMFdbGWS TntAfNQD+jiF4UY5Tko6SiIb19hBoBEDKJBzNdBdi7gLedoIoJ/0GYH5YHZw4qljpd00 6ngCIQXhPhc7Qh6lB4lEyKJ31hZSIpP12G4lRskTs+pwMtGEkJYJU7AO1gd7mc3oJIvr rxFJQO5Rre8Mvk1iR5Hq+Ncx7m47jyeMmxZ2irqUaABhVvUfyPUAORD/X0qvaRd3xs4/ mVJA== X-Gm-Message-State: AOAM533/hECgR1dgLhE3NCDuqf4IJS638Waw8hyDKBwBhAQN6jf4CAdb +CNRsTOtsMAWGUVtxAm5mwAHO54ZMCjavA== X-Google-Smtp-Source: ABdhPJw6LtzUwoq1PNrqrR+ZqH19crDHRD818WHGwPZFLPYO4205/Bxlp5UhlPKzKDCk2FE7NkkWGQ== X-Received: by 2002:a19:23cf:: with SMTP id j198mr9737961lfj.509.1608703202254; Tue, 22 Dec 2020 22:00:02 -0800 (PST) Received: from [1.0.0.7] ([178.155.6.51]) by smtp.gmail.com with ESMTPSA id b22sm3023333lfp.233.2020.12.22.22.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 22 Dec 2020 22:00:01 -0800 (PST) Subject: Re: BUG #16780: Inconsistent recovery_target_xid handling across platforms To: Michael Paquier , pgsql-bugs@lists.postgresql.org References: <16780-107fd0c0385b1035@postgresql.org> From: Alexander Lakhin Message-ID: <7e691f38-666e-7991-1107-f87608575560@gmail.com> Date: Wed, 23 Dec 2020 09:00:00 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 23.12.2020 07:44, Michael Paquier wrote: > On Tue, Dec 22, 2020 at 02:02:46PM +0900, Michael Paquier wrote: >> So, attached is a patch to make the logic more consistent that I would >> like to apply down to 12. Please let me know if there are any >> objections or comments. > I have looked at that again this morning, and applied a fix down to > 9.6 with the change in the TAP tests based on pg_resetwal. In 9.5, > pg_strtouint64() is not available, but this branch is old enough that > it did not seem worth the extra effort. Thank you! I think that with this change, if the check for epoch will be added someday, it will work consistently too. Best regards, Alexander