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.
I can do that, but I would think a pg_dump/restore would also have this issue, so should this be more generic? If we had a doc section about that, we could add it a step to run in the pg_upgrade instructions. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
