From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: pg_upgrade(?) not cleaning up old extensions
Date: Sat, 6 Feb 2021 13:23:53 +0100
Message-ID: <61ea1e0b-442d-e6c8-1728-916f8376aa11@gmx.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shammat@gmx.net, pgsql-admin@lists.postgresql.org
Subject: Re: pg_upgrade(?) not cleaning up old extensions
In-Reply-To: <61ea1e0b-442d-e6c8-1728-916f8376aa11@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox