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--