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@xxxxxxxxx> 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@xxxxxxxxx> wrote:On Wed, Mar 5, 2025 at 3:55 PM Edwin UY <edwin.uy@xxxxxxxxx> 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!
