Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Date
Msg-id CANzqJaCHY6GmKDmv_x-2q9LgNhRW=CG8oQ=Fx7ciE_QrKQ5o5w@mail.gmail.com
Whole thread Raw
In response to Comparing Parameters PRE- and POST- Upgrade - Any script?  (Edwin UY <edwin.uy@gmail.com>)
Responses Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
List pgsql-admin
Tree view
On Wed, Mar 5, 2025 at 3:55 PM Edwin UY <edwin.uy@gmail.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!

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Comparing Parameters PRE- and POST- Upgrade - Any script?
Next
From: Edwin UY
Date:
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?