From: Bruce Momjian <bruce@momjian.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: ALTER SYSTEM between upgrades
Date: Mon, 13 Jul 2020 19:58:49 -0400
Message-ID: <20200713235849.GA32422@momjian.us> (raw)
In-Reply-To: <20200707201821.GA24503@alvherre.pgsql>
References: <CAA4eK1K-Uc1UFP5PKZEZYGG3cnnQTksXGBgnU4BBUTVx+Y43Fw@mail.gmail.com>
<20200707201821.GA24503@alvherre.pgsql>
On Tue, Jul 7, 2020 at 04:18:21PM -0400, Alvaro Herrera wrote:
> On 2020-Jul-07, Amit Kapila wrote:
>
> > I don't think this is true. We seem to have introduced three new guc
> > variables in a 9.3.3 minor release.
>
> Yeah, backporting GUCs is not a big deal. Sure, the GUC won't appear in
> postgresql.conf files generated by initdb prior to the release that
> introduces it. But users that need it can just edit their .confs and
> add the appropriate line, or just do ALTER SYSTEM after the minor
> upgrade. For people that don't need it, it would have a reasonable
> default (probably work_mem, so that behavior doesn't change on the minor
> upgrade).
I am creating a new thread to discuss the question raised by Alvaro of
how many ALTER SYSTEM settings are lost during major upgrades. Do we
properly document that users should migrate their postgresql.conf _and_
postgresql.auto.conf files during major upgrades? I personally never
thought of this until now.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
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-hackers@postgresql.org
Cc: bruce@momjian.us, alvherre@2ndquadrant.com, pgsql-docs@postgresql.org
Subject: Re: ALTER SYSTEM between upgrades
In-Reply-To: <20200713235849.GA32422@momjian.us>
* 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