Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: pg_upgrade(?) not cleaning up old extensions
Date
Msg-id CAMkU=1wk=HtV1-rbrNyDbhsyNGeDDiu8OUpmE7skeW6CAn_FGw@mail.gmail.com
Whole thread Raw
In response to pg_upgrade(?) not cleaning up old extensions  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: pg_upgrade(?) not cleaning up old extensions
List pgsql-admin
Tree view


On Sat, Feb 6, 2021 at 7:24 AM Thomas Kellerer <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 though only 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 example output?

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: pg_upgrade(?) not cleaning up old extensions
Next
From: Tom Lane
Date:
Subject: Re: pg_upgrade(?) not cleaning up old extensions