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 1uwQf0-0020uy-Ql for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:39:18 +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 1uwQew-0033q3-NX for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:39:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uwQew-0033pv-Ca for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:39:14 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uwQet-0003nC-0k for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:39:14 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-746d7c469a8so4760133a34.3 for ; Wed, 10 Sep 2025 12:39:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757533150; x=1758137950; 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=TL59A09ldKph8nsyrck9hLSOssOU7vl5YXtDCokgDHw=; b=nRtxJ/SqCkMoXr1pYP3nao5vkmJNSLyRwEAX0khkUmkeMKL9sCg/6zsHA+PXWXxWeM LnO5XIhbwj1+T4fuAokTS8u1rfKOvp/K1r4nBXYXwDmBUvQCSvkaF3FvpkZrmeJw9wPd C0oC4Mh/Pkm4MzGe1aRhGJn8+i8uufzPH6MqhjNwG8EyVbKBC8ecpUoKNWWmz0bdsCiy eFUhG3coRco/Ty8h4WoR8GOwpLFBJU0j8GIufDVBnfl0jTQe8Nd5Obbl7EMTvxpYVd4i qE7ilqOYIaE1NGgZkQbieXecEaTpR5LgT2GpB+JdsyF7qLb75nfwfdzs5S1w1+sGeBhT ViJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757533150; x=1758137950; 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=TL59A09ldKph8nsyrck9hLSOssOU7vl5YXtDCokgDHw=; b=NdAl/ZTDwT8+D0DzqghwmkSOa9HfndqaofAZBffHQ6WUTYSkWo3zaesZ7ZVTgMaI/W HdrS8/UZZJ+9aBtczV3lf8m/AFm43DsRLl15d5GdVQeXXn6pMbT5tH+SvVZHZe43FaZP Gh+UvvenWadmGXyZ7S8W2vV+ZJ/7ErJ86mnGXX9IptDGMsYt6a90wLFuAfS53HLP+hN1 /7b42Fpf3rJIMargLBrYpQFhdIc2FA8EiQBz8OtAA9qajUAIGu8ixtHwG0IoVHPiagbx iXgqHym5q+YM2fD+EeEy5clVCPE3Zp8/PfR/ENZq/CsHkURvn3PAgChmTvdJf07gleiy n1Hg== X-Gm-Message-State: AOJu0YykblgubouxQnXYih2DP5Pt3zRKY5/GTKp5Hu+E29gt6U+8gyY+ a1S0fMwaEYa4ZjPNbveW8GNXspHYgEBzVEuvOe+tKWTruvSTrNPxE5VxOAI0ntLpoIJJ1apWe95 iG4W7U0/DQ+x857yBf0pOeluL5TWKvyhxMA== X-Gm-Gg: ASbGnct5HaW9zFioqghb0SofrMLnhYUGUlxHGD1wfoDbh7kK4HzRfemRUCul/xBgG/Z gE5sphyt8eI5q8Cw7KfLvhUMwzmYnhTNefMfm5wPHormwlFXqDajTjlj0dDexxGzEYlDGiZTPfa rbaq4mini+hXXMZ/8+j3Q4CJZHZlmRINwM0wCOSKcq8S8nu4nKYGelV/OgNUpZUHinOC1XEyYYm pxVEM8kgsEeRs/7JA== X-Google-Smtp-Source: AGHT+IFZ2fUwzQG6nLt0nUZfk6Zhz7FoyH9IVUuvbUWTYEXu57lbS8mNFbSGIYH8fj03YrxleUqs4wPFCgQFZohbsNY= X-Received: by 2002:a05:6830:64cc:b0:741:bf2f:ee88 with SMTP id 46e09a7af769-74c7641a99cmr8676347a34.24.1757533150581; Wed, 10 Sep 2025 12:39:10 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6a6f:0:b0:5df:b5f6:b71 with HTTP; Wed, 10 Sep 2025 12:39:09 -0700 (PDT) In-Reply-To: <04f101dc2288$121b2de0$365189a0$@msym.fr> References: <04f101dc2288$121b2de0$365189a0$@msym.fr> From: "David G. Johnston" Date: Wed, 10 Sep 2025 12:39:09 -0700 X-Gm-Features: Ac12FXwRd9TkzB5wbWaoDOzhN3ftog-zqh6THt_vvtQmxOrd8Li_1RwwglWuCSc Message-ID: Subject: Re: values of column source in pg_settings To: "msalais@msym.fr" Cc: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000001f1de7063e7793c2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001f1de7063e7793c2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, September 10, 2025, wrote: > postgres# select name, source from pg_settings where source like > 'environ%'; > > name | source > > -----------------+---------------------- > > max_stack_depth | environment variable > > > > What is the meaning of =E2=80=98environment_variable=E2=80=99 here? > > Operating system and/or shell variable. Established in the parent process=E2=80=99s environment before starting the server. Think =E2=80=9Chome=E2=80=9D and =E2=80=9Cpath=E2=80=9D. David J. --0000000000001f1de7063e7793c2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, September 10, 2025, <m= salais@msym.fr> wrote:
<= p class=3D"MsoNormal">postgres# select= name, source from pg_settings where source like 'environ%';=

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0source=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0

-----------------+----------------------<= u>

max_stack_depth | environment variable

=C2=A0<= /u>

What is the meani= ng of =E2=80=98environment_variable=E2=80=99 here?


Operating system and/or= shell variable.=C2=A0 Established in the parent process=E2=80=99s environm= ent before starting the server.

Think =E2=80=9Chom= e=E2=80=9D and =E2=80=9Cpath=E2=80=9D.

David J. --0000000000001f1de7063e7793c2--