On Thursday, July 15, 2021, Jan Wieck <
jan@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.