On Thursday, July 15, 2021, Jan Wieck <j...@wi3ck.info> wrote: > On 7/15/21 4:24 PM, David G. Johnston wrote: > > OK, especially as this seems useful outside of pg_upgrade, and if done >> separately is something pg_upgrade could just run as part of its new >> cluster evaluation scripts. Knowing whether an extension is outdated >> doesn't require the old cluster. >> > > Knowing that (the extension is outdated) exactly how? Can you give us an > example query, maybe a few SQL snippets explaining what exactly you are > talking about? Because at this point you completely lost me. >
I was mostly going off other people saying it was possible. In any case, looking at pg_available_extension_versions, once you figure out how to order by the version text column, would let you check if any installed extensions are not their latest version. David J.