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 CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com
Whole thread Raw
In response to Re: 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
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.uy@gmail.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@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!


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

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Next
From: Achilleas Mantzios - cloud
Date:
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?