Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uHjrn-008amf-S3 for pgsql-sql@arkaria.postgresql.org; Wed, 21 May 2025 13:52:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uHjrm-007Cgp-5h for pgsql-sql@arkaria.postgresql.org; Wed, 21 May 2025 13:52:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uHjrl-007Cgg-Sn for pgsql-sql@lists.postgresql.org; Wed, 21 May 2025 13:52:17 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uHjrj-0009Ga-1B for pgsql-sql@lists.postgresql.org; Wed, 21 May 2025 13:52:16 +0000 Received: by mail-ot1-x32d.google.com with SMTP id 46e09a7af769-730580b0de8so4714818a34.1 for ; Wed, 21 May 2025 06:52:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747835535; x=1748440335; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Nx9Ar1Jz4S02OrH1TNASwZHcH8AHmEo8Q0cnCXuyfRk=; b=QfPgpkZoN5YKgbvFhU4rG88GS7nB2Ule9HOv7OyQQSE5GHriA6/OS0M4AcH/BAkmmG Tfn4OO7X55ppEcBPVWXrE67lKDMUXCyfdNPZMpvh99ETreurZkS2lsDY3jsdDMnTPJbQ IbfGEGpwqle3mwZ3Rh7wUH0GpkWbzTzztAQ1I322YLeJqgB64H7A31DNa2JKxpxIFfNH MEsCpGTG5nFVyiwlIPrfGSenMnzD70H+bj24O9KeVjyBsUPc+qBaPEDadqblq5oeT8+U pr0A40psL92g0d/ddzlbhQoandUh5S6eQlKNiClgdQ4yiJfLXoFXvnyfnQCy8DAuS9EZ RSkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747835535; x=1748440335; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Nx9Ar1Jz4S02OrH1TNASwZHcH8AHmEo8Q0cnCXuyfRk=; b=LwR/2md82sKRIVDNOmDncOgfRzssveCn4hL53tVqlNoptIbl4E0Ek1WMG8DxOO+RzZ LJjeLHOXlLPmTTeEaH1w1rJc5pWsCUabO4100oLiOG00xM5j1ahDy1ZzuDSQyz8o8Atj jibMZ5pbIr4Bv6uw9ndKbWiLEMXi4xEmzBJd6cJJErBNthOXRE6Qg2v8c5YE0X8deol7 QkjTq1zR+WBp3meL6OJ8VWmt5NanSGKHRSJEgEUCUQeo0xs/JBOD3xdoNVOQxmmeiog+ jZ/UKjKrAk27J9Dy9x2lR0T9U5JPnBBufgbvuNcMA48QjPtaiyexNGAX8hCipJxA0H2G Gyiw== X-Gm-Message-State: AOJu0YzvH1zCpV8tEAgyTtQIKFex5wYciyDU9x2YtJQZFTSQz7UXTcmL Wh0viAJqXlBPFtI0AQyFX0JzAF4KXsugBXe3ASp0iq2AM5hMD9DLS7y2YkwAVyf3b/7VkYVuIjh y3sNb/Evyu2M1+u3qpx2BRhAQ3Vnamdw= X-Gm-Gg: ASbGncu7D2QFVygUoUJg6fEpDQhNyIFMsepfABmJkUrHVVEZWc4J+ZdT+PO4mwMKEXO DvG5B18NX+8hPPBPZTPB2uZppZ4g1QgiKr4TlvrRaznbhTN+YDaQv1mZzexboAMfoct/HsDrulr pEcNZkcB8sg+C0orvnpSyeM+O/97yZ2A0= X-Google-Smtp-Source: AGHT+IF2KSnDB4NXgkbAky/egOAew+rUvA9oqMLAhqDQhfGSOn+ieaubRFGJuusyH04Am6NPY20Jbvf193eOiqN51dI= X-Received: by 2002:a05:6808:2102:b0:3f6:7091:d297 with SMTP id 5614622812f47-404cd77dbaamr15153691b6e.18.1747835534728; Wed, 21 May 2025 06:52:14 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6658:0:b0:5c9:f01c:52e7 with HTTP; Wed, 21 May 2025 06:52:14 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 21 May 2025 06:52:14 -0700 X-Gm-Features: AX0GCFuCCyCNxoMRdyFTH1jNNmvuWUYEQlRzqOZPo6a01KHiq9O2qUs6qmVQpSU Message-ID: Subject: Re: Confirming precedence order of Default for GUCs To: Manav Kumar Cc: "pgsql-sql@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000002c62b20635a5ac41" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002c62b20635a5ac41 Content-Type: text/plain; charset="UTF-8" On Wednesday, May 21, 2025, Manav Kumar 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. --0000000000002c62b20635a5ac41 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, May 21, 2025, Manav Kumar <mkumar@yugabyte.com> wrote:
=C2=A0
But in = the=C2=A0https://arc.net/l/quote/qnpjwhcw (DOCS) it says ALTER DATABASE/RO= LE can override the cmd line options passed in startup packet.
<= /div>

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

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

David J.

--0000000000002c62b20635a5ac41--