To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
From: Thomas Kellerer <shammat@gmx.net>
Subject: pg_upgrade(?) not cleaning up old extensions
Message-ID: <61ea1e0b-442d-e6c8-1728-916f8376aa11@gmx.net>
Date: Sat, 6 Feb 2021 13:23:53 +0100
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: de-DE
Content-Transfer-Encoding: 7bit
Precedence: bulk

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 though only the latest one is actually used.

I did "alter extension ... update" for those that are installed in the database after running pg_upgrade. But the multiple versions even show up for extensions that are not installed.

After I did a dump & restore of the database in question, this list was cleaned and only the most recent version of the extensions were shown.

This is not a big deal, but I am curious neverthless:

Did I have another choice to cleanup that apart from doing the dump & restore?

Running "drop extension" obviously doesn't work for those that aren't installed.


Thomas