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 1uwQv3-0025Sm-A9 for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:55:53 +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 1uwQv1-0039g5-8y for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:55:51 +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 1uwQv0-0039fx-RJ for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:55:51 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uwQuz-001iZx-1R for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:55:50 +0000 Received: by mail-ot1-x333.google.com with SMTP id 46e09a7af769-74381df387fso387a34.0 for ; Wed, 10 Sep 2025 12:55:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757534148; x=1758138948; 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=9YoEEk/pi5294+2NS0qevXF9EcussTXxqcyTRcQaPIk=; b=O+1wwDcka3LDSLVNJu4RJxHBqzeUM2Vz5piLO04HbeXqrRzUBLUEiGz7jbCSHINq/I nFtC1WDKA4Rp0+D3VJpbrAGNz5/n9BBngvgjWRMORk9fC362Zy1vXJ+Po77IexYna2+d PXw7NaMF9enMoY53Thu1XvF0Xwy+h8ytW+hMIvdGdiDSBblnTSSIOIWMHm0/96aj62tp ZY6dufPCx17Aqa6hEBR9wMwnZoxTBH0aRSq9qtynAJq3Hh1jk+7w8DZlP2G2OMHewqai joXWd28FQxT/1U58HJjzNK5IBuz+YPkUOj07PhWbKab8vvjMG7O8MDiERit5REESGWpZ Vq+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757534148; x=1758138948; 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=9YoEEk/pi5294+2NS0qevXF9EcussTXxqcyTRcQaPIk=; b=AWAx4keZLhTWZhBoZe8uSTlxTPl/II+/ocJOwwNT/Hp1VKv6zk83057ey+dLZd8xHz bN310biZJeA6tXTDZ/Nbfm4HT+yFXVAFmhz78dOdJfoAPo1NJoFAkJLgsN9IZ7VrdDu0 OV4FzCQ2BgvAdQoJjUdJhxc1pxXfEFdUfbBoJRWzy/t+SGhXyPshXIh52yQ/UV5m/Vcf FEvPQhwzDjMWdnB7y0U0gjtmhszGZIocmvB9XqUutMGBgSj0Ob3+eUIX0bvYNBAu/bzZ 10zwfISDa0G8EMfbEX4FsHAm7l/MaJWnTJbFRQ0qrCcaedBiCS7sE30vZxc9hi0QAYpg 7kYQ== X-Gm-Message-State: AOJu0YwIeGkTY4ghlrblM3zoQaEQMjNlFiQf3zaV2nw3nAq3ms8Z+odC c5D6UyZ7kKP+wHo1dRazDFWK/Vkyykd/Ajzwh+Z2nKwZgwQlPBdOtJZumzFuItnfK4Q1kvwCVmQ GJrYD5M1qSVSrpCt54G1FdjmAoP/BKB8= X-Gm-Gg: ASbGncv/5mf5xrB0+G1Nz4Qi3eCd3xvBBTMb/clPEjIZY/fNPWhmCXFICEA/QyZZjOL ffoAG9wpmndL2jghdWVIsvx3C2vgmM5zjmBCmKvLdtBKoEwmkeUvW3aO6rslJIT4hO5en8O/PYW pQs905MftQS+q07Y7dCXlJtbw+/zMM8I80bDF6AnHZeJJO8gVkwaecewqGO7E9A9701JNjx6yLB xKmGcOC1hjcqw232A== X-Google-Smtp-Source: AGHT+IGazWaJYFUET1WKATm1lzFSjgczrM0XrU0lhvQOHZmdm/MRXsnAMs5xext3sF7Ns/btLZQ4ObDvhm/hTkZFbeg= X-Received: by 2002:a05:6830:64c7:b0:741:a33a:54f1 with SMTP id 46e09a7af769-74c75583cacmr6536187a34.20.1757534148536; Wed, 10 Sep 2025 12:55:48 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6a6f:0:b0:5df:b5f6:b71 with HTTP; Wed, 10 Sep 2025 12:55:47 -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:55:47 -0700 X-Gm-Features: Ac12FXwc8EOsyzIhFKYDs_KYmm0TFGC_vfCXY8NCOYpIiVN93FXBIaIGTTj86cQ 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="0000000000009ab3e1063e77ce9e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009ab3e1063e77ce9e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, September 10, 2025, wrote: > > I could find several distinct values for column =E2=80=9Csource=E2=80=9D = in pg_settings > view. Examples of these values are: client, environment variable, > configuration file, default, database, override, session. > > Are there other values? > > https://github.com/postgres/postgres/blob/9016fa7e3bcde8ae4c3d63c707143af14= 7486a10/src/backend/utils/misc/guc_tables.c#L667 David J. --0000000000009ab3e1063e77ce9e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, September 10, 2025, <m= salais@msym.fr> wrote:

I could find several distinct values f= or column =E2=80=9Csource=E2=80=9D in pg_settings view. Examples of these v= alues are: client, environment variable, configuration file, default, datab= ase, override, session.

Are there other values?



David J.
--0000000000009ab3e1063e77ce9e--