Re: pg_upgrade does not upgrade pg_stat_statements properly

On Thursday, July 15, 2021, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Thursday, July 15, 2021, Dave Cramer <davecramer@gmail.com> wrote:

      Install any custom shared object files (or DLLs) used by the old cluster

      into the new cluster, e.g., <filename>pgcrypto.so</filename>,

      whether they are from <filename>contrib</filename>

-     or some other source.

However it may be

+     necessary to recreate the extension on the new server after the upgrade

+     to ensure compatibility with the new library.

      

 My uncertainty revolves around core extensions since it seems odd to tell the user to overwrite them with versions from an older version of PostgreSQL.

Ok. Just re-read the docs a third time…no uncertainty regarding contrib now…following the first part of the instructions means that before one could re-run create extension they would need to restore the original contrib library files to avoid the new extension code using the old library.  So that whole part about recreation is inconsistent with the existing unchanged text.