Date: Tue, 18 Mar 2025 16:46:38 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
Message-ID: <Z9nbrpD83Fj-AJmJ@momjian.us>
References: 
 <CA+wokJ9N04u2xr5swC4KDufieb617-idM5AS6M9je2dT58wLfw@mail.gmail.com>
 <CANzqJaCHY6GmKDmv_x-2q9LgNhRW=CG8oQ=Fx7ciE_QrKQ5o5w@mail.gmail.com>
 <CA+wokJ_eK9RTaRYXfVaCSfzfbc1Xn2TxTXfjOOBdWv9DP=yG0Q@mail.gmail.com>
 <CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/Z9nbrpD83Fj-AJmJ%40momjian.us>
Precedence: bulk

On Wed, Mar  5, 2025 at 04:24:24PM -0500, Ron Johnson wrote:
> 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.

You can query just the changed values with:

	SELECT name, current_setting(name), source
	FROM pg_settings
	WHERE source NOT IN ('default', 'override');

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.