Re: Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1 - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1
Date
Msg-id 2f43bc519f6d79f3f9226eff1a0b1495ee07b379.camel@cybertec.at
Whole thread Raw
In response to Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1  ("M.Yousaf Maqsood" <m.yousaf.maqsood@gmail.com>)
List pgsql-admin
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.
>
> 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



pgsql-admin by date:

Previous
From: SOzcn
Date:
Subject: Troubleshooting - PostgreSQL Session CPU Analyze
Next
From: Ron Johnson
Date:
Subject: Re: Lot of postmaster processes