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@xxxxxxxxxx> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
