public inbox for [email protected]  

help / color / mirror / Atom feed

Confirming precedence order of Default for GUCs
3+ messages / 3 participants
[nested] [flat]

* Confirming precedence order of Default for GUCs
@ 2025-05-21 08:06  Manav Kumar <[email protected]>
  0 siblings, 2 replies; 3+ messages in thread

From: Manav Kumar @ 2025-05-21 08:06 UTC (permalink / raw)
  To: [email protected]

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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Confirming precedence order of Default for GUCs
@ 2025-05-21 13:35  Tom Lane <[email protected]>
  parent: Manav Kumar <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2025-05-21 13:35 UTC (permalink / raw)
  To: Manav Kumar <[email protected]>; +Cc: [email protected]

Manav Kumar <[email protected]> writes:
> Can you please correct me regarding the precedence order of overriding the
> DEFAULT values for GUC's.

The precedence order is determined by the GucSource enum:

https://github.com/postgres/postgres/blob/master/src/include/utils/guc.h#L111

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Confirming precedence order of Default for GUCs
@ 2025-05-21 13:52  David G. Johnston <[email protected]>
  parent: Manav Kumar <[email protected]>
  1 sibling, 0 replies; 3+ messages in thread

From: David G. Johnston @ 2025-05-21 13:52 UTC (permalink / raw)
  To: Manav Kumar <[email protected]>; +Cc: [email protected] <[email protected]>

On Wednesday, May 21, 2025, Manav Kumar <[email protected]> wrote:
>
>

> 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.
>

The docs do not say that and in fact do not describe how packet startup
options interplay with user/database settings - at least not explicitly.

The fact Tom had to point to the source code for this suggests our
documentation could use some improvement.

David J.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2025-05-21 13:52 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-21 08:06 Confirming precedence order of Default for GUCs Manav Kumar <[email protected]>
2025-05-21 13:35 ` Tom Lane <[email protected]>
2025-05-21 13:52 ` David G. Johnston <[email protected]>

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