From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: pg_upgrade(?) not cleaning up old extensions
Date: Sat, 6 Feb 2021 19:11:15 +0100
Message-ID: <75d85e74-4d01-b3c9-7772-0de1a64a1353@gmx.net> (raw)
In-Reply-To: <191204.1612631344@sss.pgh.pa.us>
References: <61ea1e0b-442d-e6c8-1728-916f8376aa11@gmx.net>
<191204.1612631344@sss.pgh.pa.us>
Tom Lane schrieb am 06.02.2021 um 18:09:
>> 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.
>
> Yes, that view is supposed to list the versions that are available
> to be installed. Typically, installation scripts for several back
> versions exist on disk. This is an artifact of the way that we
> approach providing extension upgrade capability, but it can be handy
> if you want to test SQL code against back versions.
>
> As an example, contrib/adminpack installs
>
> adminpack--1.0.sql
> adminpack--1.0--1.1.sql
> adminpack--1.1--2.0.sql
> adminpack--2.0--2.1.sql
>
> Ordinarily, when you "create extension adminpack", it runs all four
> of those scripts in sequence and you end up with the 2.1 SQL objects.
> But if you ask to install some earlier version, it just stops after
> the appropriate script. So pg_available_extensions shows 1.0, 1.1,
> 2.0, and 2.1 as available versions. (Of course, the main reason
> for having the delta scripts is to support "alter extension upgrade".)
So if it is expected to see multiple versions through that view,
then why do the multiple versions go away when I dump & reload
the database?
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, tgl@sss.pgh.pa.us
Subject: Re: pg_upgrade(?) not cleaning up old extensions
In-Reply-To: <75d85e74-4d01-b3c9-7772-0de1a64a1353@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