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 1or1aY-000074-LO for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Nov 2022 18:38:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1or1aW-0003HF-OX for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Nov 2022 18:38:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1or1aW-0003H6-C0 for pgsql-hackers@lists.postgresql.org; Fri, 04 Nov 2022 18:38:44 +0000 Received: from mail-qt1-x82f.google.com ([2607:f8b0:4864:20::82f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1or1aT-0003oX-1s for pgsql-hackers@postgresql.org; Fri, 04 Nov 2022 18:38:43 +0000 Received: by mail-qt1-x82f.google.com with SMTP id s4so3554926qtx.6 for ; Fri, 04 Nov 2022 11:38:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Oz/6gaAEImPwvAJSfdJdYfAnos1V2d6y/ami14VZnOM=; b=3nuAyZ7zespX7K/TwgkcJOOhC1PiKUMGdGTXXhXgpomoWe85d1+4mGzAQ646h8Uyqc 30r79ZEAyzd3bJMM+k99THXzpS/eFm3A7nZnyx/nApjnj79HYHquU5Bju3nBmnySNnFV Z7d/hef8vhGeYQj/CUB8oKvIC0Fvsk8K6Zy+A/6UDZakQ3Bk7w07XyQEy3nS82NwLj0U 09QYmv7i6n1+KHvEsbMbzqQQvtTMKaAqt5hmRjOiy5raeWf9LgiyGvqFXpwErNzTbuet p4bvnw8x7BFiNvYVOee7inRSrsMFpF1Xmf2cpNBXI/8kbVZApjWfAdFYNgmG4Wg6Bg0z nH0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:message-id:subject:cc :to:from:date:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Oz/6gaAEImPwvAJSfdJdYfAnos1V2d6y/ami14VZnOM=; b=o8NFdYKXCeTkTqcsVzOMij+uZhdTmLZXGPDpNrniw1430WfTF7gK27ELXESRunH9qV 6cccmT6UDiqvsINE+k+8ym43R6VNep6DVVVHVRckfYgn+LFX7QSvuQ0JDMD0pXUrpwk8 b+mI1+YXcV9EHtYUnUtNlVgkmUECFcSJqIEo+LLCEccYUpsVMKE90AyLlvWuWnOj+Pqz IO0oS2K1e9AP++zD1gjpX7gylU5FEwxAVP8Mf1l9J3s7024y097eK+LVDI6Lvhg6aA3s y6ohZUT+JdVHyVXJ+dKXapa4JxOQ3ZCprtJjRlGuz9EToN5cr4lcRmfccn7CohIuk59y f1kA== X-Gm-Message-State: ACrzQf0TEmttkviFmjn1sOoayw4WILk+d8XNnAOOo+mljaaBdgDFr99R gDklI+cw/q185o7ifQh+HGRjIg== X-Google-Smtp-Source: AMsMyM7f0kOzIbqqbDR3QLFV1b6qi6N44HcpzpKGhqN+46gQ/TWHIxqpcnSie+OcakYvidczd82ZCg== X-Received: by 2002:ac8:5e4d:0:b0:39e:cc0d:3428 with SMTP id i13-20020ac85e4d000000b0039ecc0d3428mr29554179qtx.44.1667587120213; Fri, 04 Nov 2022 11:38:40 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id ay29-20020a05622a229d00b0039cd4d87aacsm31598qtb.15.2022.11.04.11.38.39 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 04 Nov 2022 11:38:39 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 937128009D6; Fri, 4 Nov 2022 13:38:38 -0500 (CDT) Date: Fri, 4 Nov 2022 13:38:38 -0500 From: Justin Pryzby To: David Christensen Cc: Ian Lawrence Barwick , Michael Paquier , Matthias van de Meent , pgsql-hackers@postgresql.org Subject: Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Message-ID: <20221104183838.GD16921@telsasoft.com> References: <20221104140238.GA16921@telsasoft.com> <4E379ADE-1FC3-4D53-BE46-562BDC77C5FE@crunchydata.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4E379ADE-1FC3-4D53-BE46-562BDC77C5FE@crunchydata.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Nov 04, 2022 at 09:16:29AM -0500, David Christensen wrote: > On Nov 4, 2022, at 9:02 AM, Justin Pryzby wrote: > > On Fri, Nov 04, 2022 at 11:52:59AM +0900, Ian Lawrence Barwick wrote: > >> 2022年5月3日(火) 8:45 David Christensen : > >>> > >>> ...and pushing a couple fixups pointed out by cfbot, so here's v4. > >> > >> cfbot reports the patch no longer applies [1]. As CommitFest 2022-11 is > >> currently underway, this would be an excellent time to update the patch. > > > > More important than needing to be rebased, the patch has never passed > > its current tests on windows. > > > > As I recall, that's due to relying on "cp". And "rsync", which > > shouldn't be assumed to exist by regression tests). > > I will work on supporting the windows compatibility here. Is there some list of guidelines for what you can and can’t use? I don’t have a windows machine available to develop on. I think a lot (most?) developers here don't have a windows environment available, so now have been using cirrusci's tests to verify. If you haven't used cirrusci directly (not via cfbot) before, start at: src/tools/ci/README There's not much assumed about the build environment, and not much more assumed about the test environment. Most of the portability is handled by using C and perl. I think there's even no assumption that "tar" is available (except maybe for building releases). This patch should avoid relying on tools that aren't already required. As a practical matter, cfbot needs to pass, not only to demonstrate that the patch consistently passes tests, but also because if the patch were merged while it failed tests in cfbot, it would cause every other patch to start to fail, too. > Was it failing on windows? I was attempting to skip it as I recall. I don't see anything about skipping, and cirrus's logs from 2 commitfests ago were pruned. I looked at this patch earlier this year, but never got around to replacing the calls to rsync and cp. -- Justin