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 1n8elV-0004IM-Cr for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 08:50:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8elT-0001Ph-95 for pgsql-hackers@arkaria.postgresql.org; Sat, 15 Jan 2022 08:50:23 +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 1n8elS-0001PY-UU for pgsql-hackers@lists.postgresql.org; Sat, 15 Jan 2022 08:50:23 +0000 Received: from mail-pl1-x62c.google.com ([2607:f8b0:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n8elP-0007fU-Gf for pgsql-hackers@lists.postgresql.org; Sat, 15 Jan 2022 08:50:21 +0000 Received: by mail-pl1-x62c.google.com with SMTP id n11so13167261plf.4 for ; Sat, 15 Jan 2022 00:50:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=32Ge2HAftZrT5Vzv0YzPCr7AHhE17rILm7chx/lSaFw=; b=pXPggbK1MMLFhPLguasNhjqEGbDLx4D5qnTX1OTLhwYqSybrfJaUDVeUY72xqMIrkV D1uyfkKPsqkKcwbbOy9ughq7MNHV0RiP/SrRznVUFyBLMhHp7ByKa5spF2RjBaLpFJ8V uFjF/kunpI8OaUbF3hCB6GFZUEwJjSJGWYj92zo1Seczdbh2+GkvAcIwvkfddk0oXY6h Hx4iVqvM6YrRaJO1LMCIFzX6YSYLKuz67Dij9XQa7Ew0YrqTdehAKsq5hUS9r6eP4sSg fVkfJg7zjCFueVF1QgIgjaA2PwNfHn+lKhH5oh0mu7lcFSV6GSTWQYkhtC2NsXafOey5 CBdQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=32Ge2HAftZrT5Vzv0YzPCr7AHhE17rILm7chx/lSaFw=; b=klhRbfCjmITb9SeSqfm1xKi7p3fWTipCUNFxnSiYnZuvUWpBTlHfsseuYDg45etXeV 8d0aRK3VBec6wIzzHMUmbFkLN6+PNLM9Txs+3C3zAQ/7EX7x8V9t/0bYaw8cwxmAq1zu NuJR66DGaHjO+1Qo0JaNVvn1o2bS8j80qi4ReqhyE63P/rCDpv3MuFy8BOScpnmktk/3 aICzswT0mwkoYHBqSpYIZYF8U3kX+Gr6EoITzxVndHq2esOknSMZSMMyhSYgIJHnMQSv tYel79frXFsSNVgNIllQHneQy4kr6rDdWtxTUJLFCpLGQRxHDQ6XlHsN1Y+3YOYSDTYJ mbMA== X-Gm-Message-State: AOAM530+M3gGegQamauwpd/nDQMoMFwTlTrcYoLKwoj+tILU9iNREW2D ocinb5YadRblwa/6yPylQhQ= X-Google-Smtp-Source: ABdhPJyMUOFB/EDkP224ZiApqKUdnMxn6IYM7QLCBgE8IbRCSkkewzU7MBgJRdipgKN7Aqc1+SkFxQ== X-Received: by 2002:a17:902:8a89:b0:149:a833:af2a with SMTP id p9-20020a1709028a8900b00149a833af2amr13838597plo.153.1642236618479; Sat, 15 Jan 2022 00:50:18 -0800 (PST) Received: from jrouhaud (1-171-185-43.dynamic-ip.hinet.net. [1.171.185.43]) by smtp.gmail.com with ESMTPSA id c11sm8384328pfv.85.2022.01.15.00.50.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 15 Jan 2022 00:50:17 -0800 (PST) Date: Sat, 15 Jan 2022 16:50:12 +0800 From: Julien Rouhaud To: "Bossart, Nathan" Cc: Michael Paquier , Bharath Rupireddy , Andres Freund , Peter Eisentraut , PostgreSQL Hackers Subject: Re: pg_replslotdata - a tool for displaying replication slot information Message-ID: <20220115085012.cqr44n63mpumyodm@jrouhaud> References: <20211201225243.hu5ygzyaxr546v52@alap3.anarazel.de> <4D880281-2732-493A-B189-5390E3772973@amazon.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4D880281-2732-493A-B189-5390E3772973@amazon.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Dec 06, 2021 at 07:16:12PM +0000, Bossart, Nathan wrote: > On 12/5/21, 11:10 PM, "Michael Paquier" wrote: > > On Thu, Dec 02, 2021 at 08:32:08AM +0530, Bharath Rupireddy wrote: > >> On Thu, Dec 2, 2021 at 4:22 AM Andres Freund wrote: > >>>> I don't have any other compelling use- cases at the moment, but I will say > >>>> that it is typically nice from an administrative standpoint to be able to > >>>> inspect things like this without logging into a running server. > >>> > >>> Weighed against the cost of maintaining (including documentation) a separate > >>> tool this doesn't seem sufficient reason. > >> > >> IMHO, this shouldn't be a reason to not get something useful (useful > >> IMO and few others in this thread) into the core. The maintenance of > >> the tools generally is low compared to the core server features once > >> they get reviewed and committed. > > > > Well, a bit less maintenance is always better than more maintenance. > > An extra cost that you may be missing is related to the translation of > > the documentation, as well as the translation of any new strings this > > would require. FWIW, I don't directly see a use for this tool that > > could not be solved with an online server. > > Bharath, perhaps you should maintain this outside of core PostgreSQL > for now. If some compelling use-cases ever surface that make it seem > worth the added maintenance burden, this thread could probably be > revisited. Ironically, the patch is currently failing due to translation problem: https://cirrus-ci.com/task/5467034313031680 [19:12:28.179] su postgres -c "make -s -j${BUILD_JOBS} world-bin" [19:12:44.270] make[3]: *** No rule to make target 'po/cs.po', needed by 'po/cs.mo'. Stop. [19:12:44.270] make[2]: *** [Makefile:44: all-pg_replslotdata-recurse] Error 2 [19:12:44.270] make[2]: *** Waiting for unfinished jobs.... [19:12:44.499] make[1]: *** [Makefile:42: all-bin-recurse] Error 2 [19:12:44.499] make: *** [GNUmakefile:21: world-bin-src-recurse] Error 2 Looking at the thread, I see support from 3 people: - Bharath - Japin - Satyanarayana while 3 committers think that the extra maintenance effort isn't worth the usage: - Peter E. - Andres - Michael and a +0.5 from Nathan IIUC. I also personally don't think that this worth the maintenance effort. This tool being entirely client side, there's no problem with maintaining it on a separate repository, as mentioned by Nathan, including using it on the cloud providers that provides access to at least the data file. Another pro of the external repo is that the tool can be made available immediately and for older releases. Since 3 committers voted against it I think that the patch should be closed as "Rejected". I will do that in a few days unless there's some compelling objection by then.