Re: Comparing Parameters PRE- and POST- Upgrade - Any script?

On Wed, Mar  5, 2025 at 04:24:24PM -0500, Ron Johnson wrote:
> The default postgresql.conf file might change across versions.
> 
> I remove everything from postgresql except for site-specific customizations,
> and copy those and pg_hba.conf over.
> 
> There's certainly no harm in doing "SELECT name, setting, unit FROM pg_settings
> ORDER BY name;" on the old instance, and then on the new instance after it's
> properly configured.

You can query just the changed values with:

    SELECT name, current_setting(name), source
    FROM pg_settings
    WHERE source NOT IN ('default', 'override');

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.