Re: Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "M(dot)Yousaf Maqsood" <m(dot)yousaf(dot)maqsood(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Loadable libraries ( pg_trgm) issue during pg_upgrade from 15.3 to 17.1
Date: 2024-12-20 12:55:18
Message-ID: 2f43bc519f6d79f3f9226eff1a0b1495ee07b379.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-12-20 14:25:25 Re: Lot of postmaster processes
Previous Message SOzcn 2024-12-20 12:23:34 Troubleshooting - PostgreSQL Session CPU Analyze