From: Scott Ribe <scott_ribe@elevated-dev.com>
To: David Barron <david.barron@zencos.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: upgrade questions
Date: Fri, 9 Feb 2024 10:07:59 -0700
Message-ID: <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com> (raw)
In-Reply-To: <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
References: <PH0PR22MB33529D6B6891D52EAF8706FCE94B2@PH0PR22MB3352.namprd22.prod.outlook.com>
> On Feb 9, 2024, at 10:00 AM, David Barron <david.barron@zencos.com> wrote:
>
> I’ve also seen references to copying over the pg_hba.conf and postgresql.conf files from the old data directory to the new.
Then you will be getting default values for the many, many parameters added to postgresql.conf between 11 & 15--and will have no explanatory entries documenting them. A much better suggestion is to diff the two, and apply customizations from the old to the new. (Also skim release notes for any that have been mooted.)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, david.barron@zencos.com, pgsql-admin@lists.postgresql.org
Subject: Re: upgrade questions
In-Reply-To: <6EF3E79A-DC46-4E47-9088-48230FE235A7@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox