Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v3FbQ-00DTSS-Vt for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 15:15:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v3FbP-002B74-03 for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Sep 2025 15:15:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v3FbO-002B6v-KH for pgsql-hackers@lists.postgresql.org; Mon, 29 Sep 2025 15:15:47 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v3FbM-000jWQ-0E for pgsql-hackers@lists.postgresql.org; Mon, 29 Sep 2025 15:15:46 +0000 Received: by mail-ej1-x634.google.com with SMTP id a640c23a62f3a-afcb7a16441so789822366b.2 for ; Mon, 29 Sep 2025 08:15:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759158943; x=1759763743; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=eMraPKUQ5j6wv4drYTZm2+yj7UrymW9eD0q621ZwZo8=; b=DUTTKwCHH+2kNQHouOXO+/66JNdbMEEo7fWH1WfpZ8JjztlPRzSdThL0sZ+JuowyLT wblg+O06h4WOiw+YYyFUQTI20SrHRfT0IIFvBCQbU6U5ZLWns1JTgexothbHdXaqpZRV IfKwNHgdFj0yDxegSxZOA5zdV+W4Usm3cQJyc+brt1YkUr2LqVhCqQ1PJSvlUn8+F8VV btXhfFu4ScaR4lSUXzEM22bAiWDTrxSNt4BgXBUSnsB7ux+F0ExYJgQwXZGo8Bb0+mKo HrfGOqZlqTgOPmalHmk5HcMWqh3Xhex4Zl2V+DgGrS5Si2xKLpq+SC9AHUzVHYX/xgUU PfuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759158943; x=1759763743; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=eMraPKUQ5j6wv4drYTZm2+yj7UrymW9eD0q621ZwZo8=; b=CHjk9JzK3uBY7psG/oDNQMmKxVZmtJEoc5zwxORT47tFOg5EghaQt8UxuATArsA5Vv DvXWOFL8+d6GpFgd55tNC42Q64plaNlmpoqxraC6psFGXZtFf5Q5qIYIaS8QfbIQecKi YnydXDZJbUoSCuh40TH4CHCy3Xj6/dqgIyeN5F7o/jZ1g5acpT92UXYbbhCECH1chddo R8JxEsKtT3QfAWnhfOKafFY+1eJX2xQJsm281Dqsey6o7e5tVb6zQd661XGgbxPypXoC 2VYmIxbyF7D545LnFqvim65l8KcTE5WGilelBM73tmT1QUsmoeO+PBj7Of3H9vJiA0PE mO1g== X-Gm-Message-State: AOJu0Yyx3sFCTuzsjEsv/vCW9JvjQv/OSmoLA/EBK/WcgQqYwfQEgMEC OQwb0j0BZUpAvWcFfeGpI5EqKDWDUp2TphcwOTr05yzzMKmnrr3DGKJUiobENbLSbX/eNOwDQ9J swpflQkyv2k0bjsIxs+J4epyHViNHf7XBEQ== X-Gm-Gg: ASbGncs3Laq7YdC2hWaufKqseMvC8cnZSxdEf+p9Pr4Itr2f967Rj/p35RGJdeChSS4 aPzRRS/8KmSgGna3QyPmel6TJfd/LUmi1Ql3grhh0PrVzYj6Ec6JWFhLWNyRCM0L0Ti/KJFAO6j bKiU2d6jLXo0ghv03iuWTT3o/d8B+il3zPGgjOoJKsCuXBGJ5CCd97GwcUb9xccp+cNAbUP9x29 pL+J+xOpyZUeThAJOVqovPO0SVSFQ== X-Google-Smtp-Source: AGHT+IGtxaN3IsV6oNcKv7RNsi9EPnFNDHXXlx89M6Bgt6H7oyI31cZT1akpH7lbkrMQ3RNGwXeAjXyA3lUzMPRwMOo= X-Received: by 2002:a17:906:794c:b0:b2b:63a9:223b with SMTP id a640c23a62f3a-b34bb9e9d44mr1962007266b.31.1759158942710; Mon, 29 Sep 2025 08:15:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Haas Date: Mon, 29 Sep 2025 11:15:31 -0400 X-Gm-Features: AS18NWAehANVmUUtnTErGfpywoU-GD2nA0uV9FdJn3928yu_up8O201JjgHtAUk Message-ID: Subject: Re: pg_waldump: support decoding of WAL inside tarfile To: Amul Sul Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Sep 25, 2025 at 4:25=E2=80=AFAM Amul Sul wrote: > > Another thing that isn't so nice right now is that > > verify_tar_archive() has to open and close the archive only for > > init_tar_archive_reader() to be called to reopen it again just moments > > later. It would be nicer to open the file just once and then keep it > > open. Here again, I wonder if the separation of duties could be a bit > > cleaner. > > Prefer to keep those separate, assuming that reopening the file won't > cause any significant harm. Let me know if you think otherwise. Well, I guess I'd like to know why we can't do better. I'm not really worried about performance, but reopening the file means that you can never make it work with reading from a pipe. --=20 Robert Haas EDB: http://www.enterprisedb.com