From a.mantzios@cloud.gatewaynet.com Fri May 15 23:23:03 2026 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 1uoiHL-008mom-8K for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 12:51:00 +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 1uoiHK-008Dp6-3I for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 12:50:58 +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 1uoiHJ-008Doy-PD for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 12:50:58 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uoiHI-000uOg-0l for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 12:50:58 +0000 Content-Type: multipart/alternative; boundary="------------KxvJ8qPgrlb6hYzFnpKtHoXb" Message-ID: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> Date: Wed, 20 Aug 2025 13:50:53 +0100 MIME-Version: 1.0 Content-Language: en-US To: "pgsql-general@lists.postgresql.org" From: Achilleas Mantzios Subject: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------KxvJ8qPgrlb6hYzFnpKtHoXb Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit pg_restore: from TOC entry 4295; 1255 596569951 FUNCTION gist_stratnum_btree(integer) postgres pg_restore: error: could not execute query: ERROR:  could not find function "gist_stratnum_btree" in file "/usr/local/pgsql/lib/btree_gist.so" Command was: CREATE FUNCTION "public"."gist_stratnum_btree"(integer) RETURNS smallint    LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE    AS '$libdir/btree_gist', 'gist_stratnum_btree'; The solution was to somehow restart 18beta1, drop btree_gist and all its dependent constraints / indexes / objects , pg_upgrade and finally re-create extension and dependent objects. --------------KxvJ8qPgrlb6hYzFnpKtHoXb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

pg_restore: from TOC entry 4295; 1255 596569951 FUNCTION gist_stratnum_btree(integer) postgres
pg_restore: error: could not execute query: ERROR:  could not find function "gist_stratnum_btree" in file "/usr/local/pgsql/lib/btree_gist.so"
Command was: CREATE FUNCTION "public"."gist_stratnum_btree"(integer) RETURNS smallint
   LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE
   AS '$libdir/btree_gist', 'gist_stratnum_btree';


The solution was to somehow restart 18beta1, drop btree_gist and all its dependent constraints / indexes / objects , pg_upgrade and finally re-create extension and dependent objects.

--------------KxvJ8qPgrlb6hYzFnpKtHoXb-- From adrian.klaver@aklaver.com Fri May 15 23:23:56 2026 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 1uojy4-009LNw-Ag for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:39:13 +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 1uojy3-008qBf-PS for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:39:12 +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 1uojy2-008qBV-QE for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:39:12 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uojy0-000rPk-2P for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:39:10 +0000 Received: from phl-compute-12.internal (phl-compute-12.internal [10.202.2.52]) by mailfout.phl.internal (Postfix) with ESMTP id 21AE0EC0519; Wed, 20 Aug 2025 10:39:08 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Wed, 20 Aug 2025 10:39:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= 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=fm2; t=1755700748; x=1755787148; bh=4CYU+97kdiUgoCVVOsyHdUoAsxDrLIZ8YPRN8PSByRo=; b= VfpaJdWsuVTzsGU27LTWO14rtY7ZJljifnAYBp9SyBg77vXEKKf96FTVGM71QXYW vtN3DsxpBhYhWgVlCr99Umq+7el4H4+X1a0NM1j6vrnoXjmTMHk3IHc7aSFgny85 hWpiSb2YjLVxgNZbNeCkqwPDe/i8lhRSp0cbIYApiSYJu/VmRUFGDK33o0KS9cPU ACoJmHHDNfF2nGNZNiMeZ5GFenPEmHzVtBjBjXeMjLRLvDjmwrRmN6/fju68U9PV NQx8y4SSNjkcfumLrL9bNFJ3SXMGVW5W8zdtoEqeJ/pAq2qUlBLCmBJrGLmXl566 jCgzLS20nE6snibuljNQXw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=1755700748; x=1755787148; bh=4 CYU+97kdiUgoCVVOsyHdUoAsxDrLIZ8YPRN8PSByRo=; b=irajQBXlfzIeHHRBm h4lsE2QbOfrGcMuNX4vFBEBEcJn6uaanyFS+HG61JaCFsrvYAQjwXcofgkUz73+i W0oi0d5poxHA45r70Qv71OUr3GUlj3qcjXgb4Xp47gtbMN+x3HpG1l6R1iBUMvQt pBmolZHuyBe26QoGFZ+m8OLMxRPImt8JwTliN8sj2pOIhQbvqC7KtFLIh6glrqyI Kqvv2dxj705pArPSoJpGNzGCYHbzOWlpOlLCgmvBUf4fM7cNAVqKF5bZHz1yJN8w UAt1Rxs+Yw++4P7rVcTH4jvLWIgy6xFYxx/+JV8+eO/Qux4IxIv2lY3NnXsuADXC 16rtQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdduheekiedvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhirghn ucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqe enucggtffrrghtthgvrhhnpeelgeevkeekkeeuiefgtdevieeluefhfedufeetkeejffek jeeujeehgeehgeektdenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghn rdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhoug gvpehsmhhtphhouhhtpdhrtghpthhtoheprgdrmhgrnhhtiihiohhssegtlhhouhgurdhg rghtvgifrgihnhgvthdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlse hlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 20 Aug 2025 10:39:07 -0400 (EDT) Message-ID: <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> Date: Wed, 20 Aug 2025 07:39:06 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension To: Achilleas Mantzios , "pgsql-general@lists.postgresql.org" References: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/20/25 05:50, Achilleas Mantzios wrote: > pg_restore: from TOC entry 4295; 1255 596569951 FUNCTION > gist_stratnum_btree(integer) postgres > pg_restore: error: could not execute query: ERROR:  could not find > function "gist_stratnum_btree" in file "/usr/local/pgsql/lib/btree_gist.so" > Command was: CREATE FUNCTION "public"."gist_stratnum_btree"(integer) > RETURNS smallint >    LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE >    AS '$libdir/btree_gist', 'gist_stratnum_btree'; I can not find gist_stratnum_btree in: https://www.postgresql.org/docs/18/btree-gist.html or in the source. How did it end up in the database? > > > The solution was to somehow restart 18beta1, drop btree_gist and all its > dependent constraints / indexes / objects , pg_upgrade and finally re- > create extension and dependent objects. > Something more then DROP EXTENSION/CREATE EXTENSION btree_gist? -- Adrian Klaver adrian.klaver@aklaver.com From pj@illuminatedcomputing.com Fri May 15 23:24:05 2026 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 1uok8M-009Ocv-Op for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:49:52 +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 1uok8L-008uGF-Oi for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:49:50 +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 1uok8L-008uG7-A6 for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:49:50 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uok8I-000vOT-2v for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:49:49 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-61bd4ff762eso3028495eaf.3 for ; Wed, 20 Aug 2025 07:49:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=illuminatedcomputing-com.20230601.gappssmtp.com; s=20230601; t=1755701384; x=1756306184; 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=XepoIWT30QYlPBFz1HE8+Uu9Q8XAppMupUfO4WvDltc=; b=dzZONOwZ/RRrXlmfT/rOtjWkxWYwZDZIF+TnR6sUHBGO8zRTLeWI3tz3G12U7LJGUD 3U7SPNDvTse/gBSlY0p7cu87AQ0OCtxHOGyaywO4BamYazCB/iPiVleVMmCTWWs3MXjZ jNTHeZ9i4fq6bc8tsfAsix/qtY9jgO3897Q8B+4bPLsNC/rQqwfrzwpZSoxk5mqCE6AL NuGyJBWnFkmHOwvirwjhk6qx4Xq3rln/24Wsr+Fw22Lpe3LxPRHZgeJSjHiMKrpLwQkj RR2i5dVPMRlRcmCKKlbnjl6K2/jb3Br3McSUzfsUtJYAoYCVbUvKDNFpBdHOwOvq0dw8 y/eA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755701384; x=1756306184; 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=XepoIWT30QYlPBFz1HE8+Uu9Q8XAppMupUfO4WvDltc=; b=mWBP/eIzpW0lNSHF8ulJhYK9Kh5LNpRrcu/w3mE02MZaQFNNMBQOIeRQ/VmsOok3BR qwItmpj+hzVlJvTCsv25TXQx7z8+TNLlBT56n3i3aUhIwwtKb3DaC4A2b3778fUToLMs TCWQjCLz1y6D2+46RWQnPHs3rc4Fjmrx2oFJBaOPDKe+/NiENT+EP4IaLLl84pX8DuCr vLZjlNGfMoHxw12RO8t1GqJPStrhFrmRuWYh1eGqwG67uXEL0tr38gsXvo+hfY2LhRpv vU9pWJq8SpQ8F7E5c4+porZWNmctP9XTmtOK1xrYcw+QJ/ZuG9JuwK7/pFXKHfvr6xJs fSBg== X-Forwarded-Encrypted: i=1; AJvYcCUmSrxvDIwZzYR8+CfpkPZTk2CU1/n836aC4a4yORvFCBJDii7MptmgMKXJItgdkdewPjq8czqhH+hnT4se@lists.postgresql.org X-Gm-Message-State: AOJu0Ywu0Tlk427IkskLS402LKdJSOrXKffH3UWFjhkUouFrcJgBqJ6K gsGjdEjMKFFTUuYag3W97rF3MImqYQ9fLZqJc30f24se4wfi3JJQAxiGW8+eWDuopZD/PtB9/uZ /45mCAVvFe9ftSVJ05BROi/agloRrYS4z1c/1Olyk+g== X-Gm-Gg: ASbGnct04wfgnc8ezHG78mBrZm/+DX3OwnLLYf+paojccWufrD/QfPb8ZUoUm7vmEyo z5P+KlkIx+jA1iHUL4eQxF/ZYpGViqsoPW2ALERTs0tGo5rD5UZC0iNAmepAjgj7VsvsTHRwoTV Jq6rm/wT3bQZzDsGidWkA280hn17RsaNXlxPB9tb8r1nxtbAZePFMJBSNyI1yHM/y9QKM+dCuMa TsdXEdc X-Google-Smtp-Source: AGHT+IFQUDFl9SMNGBTqKEN7jZe+RX1OLqthzodaroo3IfSfmMtu7T5Vkyk3IamOlj0rVntTGB8fSQFG5bcOprjnqF4= X-Received: by 2002:a05:6808:6f8b:b0:435:8501:db01 with SMTP id 5614622812f47-43772019574mr1704169b6e.16.1755701383848; Wed, 20 Aug 2025 07:49:43 -0700 (PDT) MIME-Version: 1.0 References: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> In-Reply-To: <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> From: Paul A Jungwirth Date: Wed, 20 Aug 2025 09:49:31 -0500 X-Gm-Features: Ac12FXzlRflPMFv0lUIDt5SXx4azMUiCWepcysOpk74aGjCSlA6VoCVgtHpH6Zs Message-ID: Subject: Re: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension To: Adrian Klaver Cc: Achilleas Mantzios , "pgsql-general@lists.postgresql.org" 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 Wed, Aug 20, 2025 at 9:39=E2=80=AFAM Adrian Klaver wrote: > > On 8/20/25 05:50, Achilleas Mantzios wrote: > > pg_restore: from TOC entry 4295; 1255 596569951 FUNCTION > > gist_stratnum_btree(integer) postgres > > pg_restore: error: could not execute query: ERROR: could not find > > function "gist_stratnum_btree" in file "/usr/local/pgsql/lib/btree_gist= .so" > > Command was: CREATE FUNCTION "public"."gist_stratnum_btree"(integer) > > RETURNS smallint > > LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE > > AS '$libdir/btree_gist', 'gist_stratnum_btree'; > > I can not find gist_stratnum_btree in: > > https://www.postgresql.org/docs/18/btree-gist.html > > or in the source. > > How did it end up in the database? gist_stratnum_btree was in beta1 but was renamed to gist_translate_cmptype_btree by 32edf732e8dc9eb3e7a923aeb67d49246744a20a. > > The solution was to somehow restart 18beta1, drop btree_gist and all it= s > > dependent constraints / indexes / objects , pg_upgrade and finally re- > > create extension and dependent objects. > > Something more then DROP EXTENSION/CREATE EXTENSION btree_gist? That seems like the easiest fix to me. But if you've built indexes based on those opclasses then more work is required, as here. I don't know what pg_upgrade tries to support for moving from one beta release to another. Is this something we should try to fix? Yours, --=20 Paul ~{:-) pj@illuminatedcomputing.com From tgl@sss.pgh.pa.us Fri May 15 23:23:09 2026 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 1uokEc-009QU8-6s for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:56:19 +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 1uokEa-008xgg-EP for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:56:17 +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 1uokEa-008xgX-3a for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:56:16 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uokEW-000rWm-26 for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:56:15 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 57KEu6XD1020134; Wed, 20 Aug 2025 10:56:06 -0400 From: Tom Lane To: Adrian Klaver cc: Achilleas Mantzios , "pgsql-general@lists.postgresql.org" Subject: Re: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension In-reply-to: <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> References: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> Comments: In-reply-to Adrian Klaver message dated "Wed, 20 Aug 2025 07:39:06 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1020132.1755701766.1@sss.pgh.pa.us> Date: Wed, 20 Aug 2025 10:56:06 -0400 Message-ID: <1020133.1755701766@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Adrian Klaver writes: > I can not find gist_stratnum_btree in: > https://www.postgresql.org/docs/18/btree-gist.html > or in the source. > How did it end up in the database? See commit 32edf732e. Perhaps that renaming should not have been done post-beta1, but that's where we are. regards, tom lane From tgl@sss.pgh.pa.us Fri May 15 23:23:30 2026 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 1uokGl-009R9h-Tf for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:58:33 +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 1uokGl-009217-BD for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 14:58:31 +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 1uokGl-00920y-0t for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:58:31 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uokGj-000rXp-0v for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 14:58:30 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 57KEwNTg1020349; Wed, 20 Aug 2025 10:58:23 -0400 From: Tom Lane To: Paul A Jungwirth cc: Adrian Klaver , Achilleas Mantzios , "pgsql-general@lists.postgresql.org" Subject: Re: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension In-reply-to: References: <4d301501-9985-4e68-b1c1-2360c251048c@cloud.gatewaynet.com> <54d352ad-3f64-4492-aaaf-1ebaeac5471c@aklaver.com> Comments: In-reply-to Paul A Jungwirth message dated "Wed, 20 Aug 2025 09:49:31 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1020347.1755701903.1@sss.pgh.pa.us> Date: Wed, 20 Aug 2025 10:58:23 -0400 Message-ID: <1020348.1755701903@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Paul A Jungwirth writes: > I don't know what pg_upgrade tries to support for moving from one beta > release to another. Is this something we should try to fix? It's water over the dam now, I think. If we had such a breakage between officially-released versions, that would be bad enough to justify jumping through hoops. But beta releases have always been "use at your own risk". regards, tom lane