Re: pg_upgrade(?) not cleaning up old extensions - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: pg_upgrade(?) not cleaning up old extensions
Date
Msg-id 4262c6e7-e8fd-d1d9-fc1f-a419403a4cb4@gmx.net
Whole thread Raw
In response to Re: pg_upgrade(?) not cleaning up old extensions  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
Jeff Janes schrieb am 06.02.2021 um 19:42:
> On Sat, Feb 6, 2021 at 7:24 AM Thomas Kellerer <shammat@gmx.net <mailto:shammat@gmx.net>> wrote:
>
>     Hello,
>
>     I have a (test) database that has been upgraded several times from 9.4 to 13 using pg_upgrade.
>
>     I have noticed that when I look at pg_available_extensions many extensions are listed with multiple versions even
thoughonly the latest one is actually used. 
>
>
> I can't reproduce this.  Are you sure you aren't looking at pg_available_extension_versions ?  Could you show some
exampleoutput? 


Hmm, I could have sworn I was looking at pg_available_extensions - but maybe I wasn't.

But as I can't reproduce this after a dump & reload and it's really not a big deal,
let's just assume I was indeed using the wrong view.

Thomas



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgrade(?) not cleaning up old extensions
Next
From: Mariane Kiesewetter
Date:
Subject: Re: Disconnection errors