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

FYI, found this one and it helps.
Now I have to figure out how to format it 'nicely' when you have a long
string of sort for current_value so that it displays 'nicely'.
Will ask for help in the UNIX forum

https://www.christophermaier.name/2010/04/27/comparing-settings-from-different-postgresql-databases/

P.S.: darn it, I need a new job remotely to get more skills :( paid/unpaid
just to get ore real more interesting experience

On Wed, Mar 19, 2025 at 9:46 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:

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