On Fri, Jul 30, 2021 at 12:40:06PM -0400, Bruce Momjian wrote: > On Thu, Jul 29, 2021 at 06:19:56PM -0400, Tom Lane wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > I think we need to first give clear instructions on how to find out if > > > an extension update is available, and then how to update it. I am > > > thinking we should supply a query which reports all extensions that can > > > be upgraded, at least for contrib. > > > > I suggested awhile ago that pg_upgrade should look into > > pg_available_extensions in the new cluster, and prepare > > a script with ALTER EXTENSION UPDATE commands for > > anything that's installed but is not the (new cluster's) > > default version. > > OK, done in this patch. I am assuming that everything that shows an > update in pg_available_extensions can use ALTER EXTENSION UPDATE. I > assume this would be backpatched to 9.6.
Patch applied through 9.6. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.