RE: BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17 - Mailing list pgsql-bugs

From Bing Xu
Subject RE: BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17
Date
Msg-id PH0PR08MB77481A8BEAF278E92E6E8119B97F2@PH0PR08MB7748.namprd08.prod.outlook.com
Whole thread Raw
In response to Re: BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17
List pgsql-bugs

Hello


Dear David

 

>You will,need to uninstall that extension from all of your databases before you can upgrade to a version that does not include it.

I uninstalled adminpack from the database and was able to upgrade to PostgreSQL 17 normally,

but why is there no record in the PostgreSQL 17 upgrade manual?

 

https://www.postgresql.org/docs/current/pgupgrade.html

 

best regards xu

 

From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Friday, September 27, 2024 10:47 PM
To: Bing Xu <bing.xu.uh@fujifilm.com>; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18635: " $libdir/adminpack could not be loaded" error with pg_upgrade to PostgreSQL17

 

On Thursday, September 26, 2024, PG Bug reporting form <noreply@postgresql.org> wrote:

The following bug has been logged on the website:

Bug reference:      18635
Logged by:          xu bing
Email address:      bing.xu.uh@fujifilm.com
PostgreSQL version: 17.0
Operating system:   windows server 2019 Datacenter
Description:       

■Additional infos
  I saw that Release Notes said that  adminpack contrib extension has been
Removed, but why is it still used in pg_upgrade of PostgreSQL17.
  Also please tell me the solution.

-------------------------------------
●Remove adminpack contrib extension (Daniel Gustafsson) §
 This was used by now end-of-life pgAdmin III.

https://www.postgresql.org/docs/release/17.0/
----------------------------------------------------

 

You will,need to uninstall that extension from all of your databases before you can upgrade to a version that does not include it.

 

David J. 

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
Next
From: vignesh C
Date:
Subject: Re: BUG #18644: ALTER PUBLICATION ... SET (publish_via_partition_root) wrong/undocumented behavior.