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 1upYSX-007dEC-Bm for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Aug 2025 20:34:02 +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 1upYRW-0080yz-RI for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Aug 2025 20:32:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upYRW-0080yT-22 for pgsql-hackers@lists.postgresql.org; Fri, 22 Aug 2025 20:32:59 +0000 Received: from fout-a3-smtp.messagingengine.com ([103.168.172.146]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1upYRT-001FHo-2m for pgsql-hackers@lists.postgresql.org; Fri, 22 Aug 2025 20:32:57 +0000 Received: from phl-compute-07.internal (phl-compute-07.internal [10.202.2.47]) by mailfout.phl.internal (Postfix) with ESMTP id 6CAB6EC00A0; Fri, 22 Aug 2025 16:32:55 -0400 (EDT) Received: from phl-imap-05 ([10.202.2.95]) by phl-compute-07.internal (MEProxy); Fri, 22 Aug 2025 16:32:55 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1755894775; x=1755981175; bh=3BM5ZjX+Ql8PwAWiMld/+rkAgajErtkrSqSwZECCS4k=; b= PZDzwwFudLGWhtHE6XENsiyUN9Ykd6wltzF0oucl8SW96gjnFpLIxUTVtmjw1Rao iRsswH8lfqB2Q07//24T607tg+R48hhf0cW/sHCX7IX11NfhNf90SN9GVua8dJKT NmX02EqgwIE02ybAEuv17xKYBEBnjlp6BkggYik6FKxgi8d0WrbMRXuZaPi1cuH5 6BOo5yRx9j8s1nCMVfX5ywtsBRHfCPESJHdS+4kWGxReGgkx5UCHXRP1Ol859znh mjQdn7Lgnumhk2xgEdq8NkghluOJQ8F+syJoGq3TPZJScDrYzvKeSv6LshjlqrID Wi7vDaRPbxQyuBQvu11Kfw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1755894775; x= 1755981175; bh=3BM5ZjX+Ql8PwAWiMld/+rkAgajErtkrSqSwZECCS4k=; b=l pMUzc2toSQWlUq2cOsUQv5Do5swo6tir2Djb9GQmZUvxszrJ9tVI5xFd6/gLWPn2 ocp1I+65U8djPvcrvb1C2xvBGGZBPu6dU8/Cs5r12QBtFt3v72r/p3V4kiTp+lR0 opCOrZMZWAYRJTIb/WKbmB87lF6WX0GThqKErikDzzAVDE2E6Kwer/vUmAKV76wW 7l7sT/r73kqZ2LmLf73rMUQ9WX+iNQQjm/tfbh4GrLALGeej6Mg1SjrQWUIpsPjw oMleaAq5GS8gwnfOy7m9NlyWHwtOJfTCr4QFEULeG5+Gku9HpNDD/2pIgObvvZRX VAWK/La6KdPMslbZaDQew== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdduieegjedvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepofggfffhvfevkfgjfhfutgfgsehtqhertdertdejnecuhfhrohhmpedfgfhulhgv rhcuvfgrvhgvihhrrgdfuceovghulhgvrhesvghulhgvrhhtohdrtghomheqnecuggftrf grthhtvghrnhepffduueeikeekgfegvddvueelkedvjeetiefhfeffkeeiteeiiefhkeeu vddugedtnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvghnthgvrhhprh hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomhepvghulhgvrhesvghulhgvrhhtohdrtghomhdpnhgspghrtghpthhtohepie dpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprghhsegthigsvghrthgvtgdrrght pdhrtghpthhtohepmhgrshgrohdrfhhujhhiihesghhmrghilhdrtghomhdprhgtphhtth hopehmihhhrghilhhnihhkrghlrgihvghusehgmhgrihhlrdgtohhmpdhrtghpthhtohep rghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhrtghpthhtohepphhgshhqlhdqhh grtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohep rhhosgesgiiiihhllhgrrdhnvght X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id AC23E1820074; Fri, 22 Aug 2025 16:32:54 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: Ad2ggO7pmj7N Date: Fri, 22 Aug 2025 17:32:34 -0300 From: "Euler Taveira" To: =?UTF-8?Q?=C3=81lvaro_Herrera?= , "Robert Treat" Cc: "Pg Hackers" , "Antonin Houska" , "Fujii Masao" , "Mihail Nikalayeu" Message-Id: In-Reply-To: <202508220940.u6qkixbhu7xs@alvherre.pgsql> References: <202508220940.u6qkixbhu7xs@alvherre.pgsql> Subject: Re: Adding REPACK [concurrently] 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 Fri, Aug 22, 2025, at 6:40 AM, =C3=81lvaro Herrera wrote: > On 2025-Aug-21, Robert Treat wrote: > >> What's the plan for clusterdb? It seems like we'd ideally create a >> stand alone pg_repackdb which replaces clusterdb and also allows us to >> remove the FULL options from vacuumdb. > > I don't think we should remove clusterdb, to avoid breaking any scripts > that work today. As you say, I would create the standalone pg_repackdb > to do what we need it to do (namely: run the REPACK commands) and leave > vacuumdb and clusterdb alone. Removing the obsolete commands and > options can be done in a few years. > I would say that we need to plan the removal of these binaries (clusterd= b and vacuumdb). We can start with a warning into clusterdb saying they should= use pg_repackdb. In a few years, we can remove clusterdb. There were complai= nts about binary names without a pg_ prefix in the past [1]. I don't think we need to keep vacuumdb. Packagers can keep a symlink (va= cuumdb) to pg_repackdb. We can add a similar warning message saying they should = use pg_repackdb if the symlink is used. [1] https://www.postgresql.org/message-id/CAJgfmqXYYKXR%2BQUhEa3cq6pc8dV= 0Hu7QvOUccm7R0TkC%3DT-%2B%3DA%40mail.gmail.com --=20 Euler Taveira EDB https://www.enterprisedb.com/