Re: Comparing Parameters PRE- and POST- Upgrade - Any script? - Mailing list pgsql-admin

> On Mar 5, 2025, at 2:18 PM, Edwin UY <edwin.uy@gmail.com> wrote:
>
> Thanks, I thought pg_upgrade will somehow insert/update it with new parameters of sorts.

No. So you wind up with new parameters just getting defaults, and not specified or documented in the file.

Couple of ways around this:

- Put your parameters in a separate file that's included into postgresql.conf.
- Generate a new db, diff its config against the old one to see what's new that you might want to change, and use it
withthe inclusion of your settings.