public inbox for [email protected]  

help / color / mirror / Atom feed

From: Manav Kumar <[email protected]>
To: [email protected]
Subject: Confirming precedence order of Default for GUCs
Date: Wed, 21 May 2025 13:36:56 +0530
Message-ID: <CAPhCW+_sxtUDCcJd0=WN4iC6Ag33QQ0-ifrGY5mspSechVrb6A@mail.gmail.com> (raw)

Hi Team,
Can you please correct me regarding the precedence order of overriding the
DEFAULT values for GUC's.

Is it right to say, GUC passed in the start up packet will override the
default value set by using ALTER DATABASE/ROLE. ?
I've verified by running locally.
But in the https://arc.net/l/quote/qnpjwhcw (DOCS) it says ALTER
DATABASE/ROLE can override the cmd line options passed in startup packet.
Also just below that paragraph for Interaction with Shell, it says about
startup/cmd line options only overriding the default set via alter system
or postgresql.conf

Please correct me is it correct order of applying the defaults:

1. Using start up packet (i.e using env var or passing cmd line option)
2. Using alter database/role
3. Setting via postgresql.conf or using alter system

Looking forward to hearing the response.
Thanks
Manav

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Confirming precedence order of Default for GUCs
  In-Reply-To: <CAPhCW+_sxtUDCcJd0=WN4iC6Ag33QQ0-ifrGY5mspSechVrb6A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox