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!
