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 1uYAC3-0024YG-5F for pgsql-general@arkaria.postgresql.org; Sat, 05 Jul 2025 21:13:07 +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 1uYAB0-00ABVJ-VQ for pgsql-general@arkaria.postgresql.org; Sat, 05 Jul 2025 21:12:03 +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 1uYAB0-00ABVA-Kr for pgsql-general@lists.postgresql.org; Sat, 05 Jul 2025 21:12:03 +0000 Received: from mail69.out.titan.email ([3.216.99.51]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uYAAw-005x4W-0T for pgsql-general@lists.postgresql.org; Sat, 05 Jul 2025 21:12:01 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp-out.flockmail.com (Postfix) with ESMTP id 6FB61140023 for ; Sat, 5 Jul 2025 21:11:56 +0000 (UTC) DKIM-Signature: a=rsa-sha256; bh=vIHZwpDAtFkyy8Yd6P58R/7Zj/YlFIJk0uFVXOhV2iA=; c=relaxed/relaxed; d=pfortin.com; h=from:in-reply-to:mime-version:to:references:date:subject:message-id:from:to:subject:date:message-id:in-reply-to:references:cc:reply-to; q=dns/txt; s=titan1; t=1751749916; v=1; b=Q3zYZc6b8MAKl+68ufxjZRhJ0z1CjuLC1u4lpHbeT2bkbXYDKDaEHSpSYmnYM4r0ywTQDumM xclmlFG0mPBb50X3f7u0Q7y7kcYXpFa4Nne9xBE8MIh9R6lv1EG76i6yVwOQ77LqeQRN1HPbiTV V/mgCkDemLBz0gtyrw7cfIw4= Received: from pfortin.com (h194.51.155.207.dynamic.ip.windstream.net [207.155.51.194]) by smtp-out.flockmail.com (Postfix) with ESMTPA id 28FBE140019 for ; Sat, 5 Jul 2025 21:11:55 +0000 (UTC) Date: Sat, 5 Jul 2025 17:11:55 -0400 Feedback-ID: :pf@pfortin.com:pfortin.com:flockmailId From: Pierre Fortin To: pgsql-general@lists.postgresql.org Subject: Re: pg_upgrade: can I use same binary for old & new? Message-ID: <20250705171155.1c857f82@pfortin.com> In-Reply-To: <6f10bec7-692f-4ae3-904d-4de59aef8e80@aklaver.com> References: <20250705125207.31b4d475@pfortin.com> <20250705142416.06e99667@pfortin.com> <6f10bec7-692f-4ae3-904d-4de59aef8e80@aklaver.com> X-Mailer: Claws Mail 4.3.1git142 (GTK 3.24.49; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-F-Verdict: SPFVALID X-Titan-Src-Out: 1751749916305908166.32042.3510434952256894076@prod-use1-smtp-out1003. X-CMAE-Score: 0 X-CMAE-Analysis: v=2.4 cv=QtKk3Uyd c=1 sm=1 tr=0 ts=6869951c a=qh1+orYxbfpu+9ysfXJjVg==:117 a=qh1+orYxbfpu+9ysfXJjVg==:17 a=kj9zAlcOel0A:10 a=CEWIc4RMnpUA:10 a=BgpjXcZQAAAA:8 a=5N45VyDCYIMmKw4fhRsA:9 a=CjuIK1q_8ugA:10 a=Jyo2sqUHqs9O1PedRBIf:22 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 5 Jul 2025 12:58:10 -0700 Adrian Klaver wrote: >On 7/5/25 11:24, pf@pfortin.com wrote: >> On Sat, 5 Jul 2025 11:11:32 -0700 Adrian Klaver wrote: >> > >> Didn't try given: >> $ df /mnt/db >> Filesystem Size Used Avail Use% Mounted on >> /dev/sdh1 17T 13T 3.0T 82% /mnt/db > >You said you have ~70TB of free space, so where is the other ~63TB? I never said "free space" with ~70TB; that's the total space on about 8 drives :) The biggest free space I have is 7.6TB which is less than the 8TB DB; but thanks to the responses, I should be able to make this work... Also, I appreciate the clarification re CREATE INDEX (Doh!) and --jobs Best, Pierre