Postgres Pro
Downloads
Home   >   mailing lists

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

From Edwin UY
Subject Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Date
Msg-id CA+wokJ_eK9RTaRYXfVaCSfzfbc1Xn2TxTXfjOOBdWv9DP=yG0Q@mail.gmail.com
Whole thread Raw
In response to Re: Comparing Parameters PRE- and POST- Upgrade - Any script?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
List pgsql-admin
Tree view
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@gmail.com> wrote:
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: Ron Johnson
Date:
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Next
From: Scott Ribe
Date:
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?