pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

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?
Date: Tue, 18 Mar 2025 16:46:38 -0400
Message-ID: <Z9nbrpD83Fj-AJmJ@momjian.us> (raw)
In-Reply-To: <CANzqJaA+F-quZOH7sdfSDUOLRsnKN4C0K_kam1gTmeS6PPFfJw@mail.gmail.com>
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>

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.

view thread (8+ messages)  latest in thread

Message-ID: <Z9nbrpD83Fj-AJmJ@momjian.us>
Permalink:  ../Z9nbrpD83Fj-AJmJ@momjian.us/
Also on:    postgresql.org/message-id/Z9nbrpD83Fj-AJmJ@momjian.us

copy link · copy postgr.es

reply

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: bruce@momjian.us, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Comparing Parameters PRE- and POST- Upgrade - Any script?
  In-Reply-To: <Z9nbrpD83Fj-AJmJ@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