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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Date: 2025-03-05 21:24:24
Message-ID: CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

On Wed, Mar 5, 2025 at 4:19 PM Edwin UY <edwin(dot)uy(at)gmail(dot)com> wrote:

> Thanks, I thought pg_upgrade will somehow insert/update it with new
> parameters of sorts.
>
> On Thu, Mar 6, 2025 at 10:03 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> wrote:
>
>> On Wed, Mar 5, 2025 at 3:55 PM Edwin UY <edwin(dot)uy(at)gmail(dot)com> wrote:
>>
>>> Hi,
>>>
>>> Does anyone know of a script that can be used to compare parameters pre-
>>> and post- upgrade?
>>> Is it something that's worth the effort though? Or is it not something
>>> to be worrying about?
>>> We only need to check pg_settings for this, is that correct?
>>>
>>
>> pg_upgrade?
>>
>> If you copy the old $PGDATA/postgresql.conf to the new $PGDATA directory,
>> then your config parameters will all be the same.
>>
>> --
>> Death to <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios - cloud 2025-03-06 08:28:00 Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Previous Message Scott Ribe 2025-03-05 21:24:11 Re: Comparing Parameters PRE- and POST- Upgrade - Any script?