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 1tOcXM-007bdy-Kw for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 12:55:25 +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 1tOcXL-00B0rZ-VX for pgsql-admin@arkaria.postgresql.org; Fri, 20 Dec 2024 12:55:23 +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 1tOcXL-00B0rQ-JW for pgsql-admin@lists.postgresql.org; Fri, 20 Dec 2024 12:55:23 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tOcXI-000ktQ-Uw for pgsql-admin@postgresql.org; Fri, 20 Dec 2024 12:55:22 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-a9a68480164so310491066b.3 for ; Fri, 20 Dec 2024 04:55:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1734699319; x=1735304119; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=mcrP3QnSnrga0ieEFJzyxmCYkzR67Z9k+IXoWP/tGsM=; b=D+IxyFUocWqpYIzwBUq6bGiRkMa7gNRJLqoNiqVEp8PSnPWKPL4QKpumroJI/EGF4k 0LH/9pcSI46pRjoaoMBfFTBE7of4S6JlYth77IZa+5exL+3LnNaAVCVGbjdHlErEFGpj t2/tEts5jhHfIgCygTiwzuDqrls/5tuQyoG52IdS8njvJ+Xaifqxs6QtbcfAr2ISkneF Gnyw3fPJl8TJZzdl4XfpcOtLmVpGlr4O4+7Aus9GIZp7RXNXMjWuK27UPC3vqu5tnlmW ZmCRPqM9GlOsjlxK5Ii2xsRu94F+WgTh6LbM1+EcJfELTi0D1uoZQJs+QgVhgU5tGGws 95pw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734699319; x=1735304119; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=mcrP3QnSnrga0ieEFJzyxmCYkzR67Z9k+IXoWP/tGsM=; b=wqlcPaZK0ZGR7LBrSq+ayIgWd1IfA9f8NB+GyQnlt28Six3aIyeIzfn/Y1xiMXtzQ8 XfuVzdWL0UNQJMmK49fjaI6E/tBlP2BRRu3+3gOTYsbcUGMtCkksq4kHEjj8i00OCLbI /7BYnx00s4BmPYcMNMnWUefKQ86/R1jc+s0Ct7tKMI/sQ94tVN08m/FZ8i0bRaim41uS KXP+4sakHTmAtMNm3tsAwb65H+b0WFPqRwu9Xbqf1+hXDxlmVUG6sBbhV5s8H+E3FaKt z2yHFEBh/rSkZWqb3HhxvX9pBGDxwg3b+cQNp9G8RrGlegGPiDCTmiQeMNHNCoXIeusL 3WTw== X-Forwarded-Encrypted: i=1; AJvYcCUZUkRjvUC9BxZ0VFdkdFxGb1Hrw3R5esxH+pq5HqGNL0WrQgUrbP2PYQXmox2zO1hor3hjWpiw/Q5sWA==@postgresql.org X-Gm-Message-State: AOJu0YxcFUB/o6Rji/7ikfDgCxHEZq2dnAqvU7cMod9lIbepOMyGT2nV kzi6CjpBA/SubKlGPhagYS3OmCeNjNFN5KG3sTWrM5VquW2E8KAIOEsOw5TcyNIA721qIf+t0ge 2 X-Gm-Gg: ASbGncsfqmLYv4sNk394rMOPMRtZLOTHv0lJ5B2VniV1uC0cjHw4mDLWc8d638B0ABH bdaqMMEGIk9WNWbWRpnoqlfknDfzTQbm6GK4OvHZEGtDuiZXUzbiU1wnOLbZI9qkmXylg431ltu crGAVF69NgG2ksoxPLjQY9OClTPaz2Iv/mTjTuvZF5fOLUSbYPyBKNUfjTTMu5mBOIUQJX7T0eZ qxj3FAwCDKxDaJ2P+xugH4+1zJu3CroWj7h0WM18w7cfJUCc6gSxYYAoSd7POCiK2hvpH/4/Q7B Gg== X-Google-Smtp-Source: AGHT+IGnfSfuoBotc0ZEQXET5QM9SfwPh0WGDwk/3lYQ6BPRlAbi8HR5gFOJBJYkCYpZpGTeyYlfIw== X-Received: by 2002:a17:907:7f88:b0:aac:2297:377d with SMTP id a640c23a62f3a-aac33683329mr204103766b.52.1734699319336; Fri, 20 Dec 2024 04:55:19 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:ea51:b5e7:c1bb:bc75:c6ee]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-aac0efe46f6sm173170166b.111.2024.12.20.04.55.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Dec 2024 04:55:19 -0800 (PST) Message-ID: <2f43bc519f6d79f3f9226eff1a0b1495ee07b379.camel@cybertec.at> Subject: Re: Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1 From: Laurenz Albe To: "M.Yousaf Maqsood" , pgsql-admin@postgresql.org Date: Fri, 20 Dec 2024 13:55:18 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.2 (3.54.2-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-12-18 at 22:13 +0500, M.Yousaf Maqsood wrote: > When I was running pg_upgrade with --check Option, it says can load load = library > pg_trgm.so because pg_popcount is undefined symbol which is being used in= pg_trgm > in 15.3 but 17.1 is unable to identify it. >=20 > Can anyone guide me ? With PostgreSQL v17 you have to use the v17 version of pg_trgm.so; you cannot just copy it from the v15 installation. Yours, Laurenz Albe