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 1uwQNc-001ujP-R9 for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:21:21 +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 1uwQNb-002voW-0W for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 19:21:19 +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 1uwQNa-002voN-IF for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:21:19 +0000 Received: from mout.kundenserver.de ([217.72.192.73]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uwQNU-0003du-2G for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 19:21:18 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=msym.fr; s=s1-ionos; t=1757532073; x=1758136873; i=msalais@msym.fr; bh=ozy9+W+puLvv5L62iD7f4Ym5nM5o23+DlQUe31sFBT8=; h=X-UI-Sender-Class:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type:cc:content-transfer-encoding:content-type:date:from: message-id:mime-version:reply-to:subject:to; b=tJo+TSgWJ8xL8j84fJ706G22DkWsmTPOu2l5cWjMGM3or6Vz1b+wDBt8T5LFxNu6 6Ew9rLZ3PdepjCU6BJiZvkyVFrGyv3/a2NJmp43Pb/aQ/ZVsQEF0q3ALkABZPKktv bIx+rl2XQHa+VbTl0AR2GbBxeUyqqCOypn6VslphCmHDFW+8a3VaohBMODO41lnMv qeMPUFIYRG4w3G/yU4RK1e4sxZc0rlU0XQEnyaZPEF23t6nPH546Vg55hqzLMBicY slGA+qR9VYdISwd5EQIhYHJe3Kg+tiPEd/IkROwoaHbb2A7STkypQrGGwmR53EP+R maUWTzOzsCpKlmzHpA== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from msim1 ([37.167.31.106]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.184]) with ESMTPSA (Nemesis) id 1MxmFk-1uDfmw2zGQ-016SFA for ; Wed, 10 Sep 2025 21:21:12 +0200 From: To: Subject: values of column source in pg_settings Date: Wed, 10 Sep 2025 21:21:10 +0200 Message-ID: <04f101dc2288$121b2de0$365189a0$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_04F2_01DC2298.D5A50F50" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AdwigRLZvSkZm+6hQOWSbkauuKOhoA== Content-Language: fr X-Provags-ID: V03:K1:AURcH8YK5GgR3UxBqKwg1ZyGpBQQz/oxa9UdGwE+zsevp3Ft1wm aOStxi6JWoAj+Pdsl4cWuqVeeJyElgbEblHSrFaB7+SkD7BoEOOWAdwFfXk2Q8zteRy5so1 7AJLh33B5XBxCSKd9Voivl04HyqB23mbsuiYKM3n0qP+9tJkyiSNUvi/ClmTzjW46TdaXtm i1E2j7lpskxvkTAxW48bg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:xiL8JBKT37I=;27Lp3juENoWudvoBjLRRmbhW6B/ vcRRgsQrglYOyyLc6wf0FDfSI58XyHPHGuNXw29YJWWdL7p8N6tZEKZzdvvEBAQ67u2g9YRwN /D856c0M7aissEMIpPgo3yhFfMwpxsIKoJcRoOAtg6h8/Df+G4Rs68xZQY9bxPBxOIQNHbaRo PMJtNkGVLJWzV+rTrJn5FfW37DTHXHixm/VIgaYXrFsAMg48hpUiWuEay0+CDru8JkxAodIyU X7hkx0MdGp+SJVLEht2X8C7k0sM6sLjIBmq4IIVAO7upXyOB1fUPmD9lqj019eYiXhqY1w0P0 dQoANkrhPdDYBup211gJ2At+g634M3dAZC1Wcl/0F9z/+32jqx3x3StYhprqEdCql/gWtyEHU iIgpU4lOAuo/HeGsKDTMH+qV4eq+KT6rgukwPHqCABIcnaOFwnduEyrhGee0iRerDseh8yiCA 2Ln4SjE/RpgCMZMX3QAjY37xHzCG94wI7OYLLZHOFVPjOuQYUoptPObUWuOPoW8HmeHgsTtRd jWS7FgSaG95SZPVCZIcyDcSbkO38+lo8E6sTYfJ4+1PLqBizVJGGvWucikjcDLyKwYMc/M2zI ycYIo5+geZivQvKlC5cqEaK4e2kg0g4BEZpbtAZYM6cMQfUSMDaSCX6Jx65PCn9byOq8UeJpP fgmCIypGzkNF65uCwLPha04WLdwX5KRLkm6ZyCZG6dkfXvWi35CVLhbQSaGLdKS9CulXjz1tg qw3J3yb3WNt8iqo0+jkdtJSkOdAnumwA3w/xSMXcmpifWzIxUozcJ7bgFmqDw1u48gn9P+FGN d/mm31htJy/X0iHCoYaKgp+yqZMOjV9JZIXOXRJ2n/vpqi8naPepiokXg0fns5imeN8FYWa73 G7hb8W3h8Xc3FZLD6OH/5hxkIvhHyAa/XmTaci+IU3BboqLQyXurh57OqSC4iNJD/bR9EXvM6 1ihgY48h9WKoSjvmwuGkLGkWkhj6LC4SWjtOWvT9aDUY68ckAUqcaid5Y11l7+RulH8uoElsa 6K2nmcWyAFxuXBO7tme1NpuCUrqCkmpMdNDKv/KoP/1LBh9cE0c17sW5hPZtk8eV+dSWfDHuO DiCUFRgh4v10sZqvCmWqsFXVfUrk7vICGU7O+176aqzVbN1hJ6lX8kTvw7uelNMOz+YUL5IVi DkLpDtQsS8v7mupHMGeYK9XfWk5nqMP0vsfV8FTdejQYDi934L+R2D1KPx4tjd69afAz7gAtN 5d2BYdKmTol2umI8Q/5+BPD7vHpSM9GK8oP5+TZMsIIrl51R2IIcXpGISUX0jLW6cawEUxrBX NuKaKY/UCBhdlt1y/wXzikte06UWXJ9Wr+GS5d0goAatrnelhwf2Zd4Af6Z0VXGlacxijrm7t KwhZqGwdhAhQ4iBI3P1zkd4ZKbLIDOClkIbngHleztb5IWyQcsMvVkRPacAZdFObPLwc+qU+r aZBee28z4Mt5dgPWIUswzHG21220wHczz65VAFLvfn7rvKKa5aMWy/lcP4KSzZn0YYlzvNgRv 4CMKmKhcEwV7vJwb60iY02raN9MpFo9NVFyLjLEKhRBCie1JxNlDi6qfqkJgKB9xNE6LE75qb f/lroEDUyMF6QmMyf1RklhDWlhcmquLX/ce2JQF/YoJWct0VpjjF8MHeDXHg2YivyVRp5R66A +WjrXwk1/Cga+8/wTnPYlm List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_04F2_01DC2298.D5A50F50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi all, =20 I could find several distinct values for column "source" in pg_settings view. Examples of these values are: client, environment variable, configuration file, default, database, override, session. Are there other values? The documentation doesn't mention any thing (Any way I didn't find). In some of my databases, I have this: =20 postgres# select name, source from pg_settings where source like 'environ%= '; name | source =20 =2D----------------+---------------------- max_stack_depth | environment variable =20 What is the meaning of 'environment_variable' here? For the other listed values, I have "almost" got it but I don't see anythi= ng for "environment variable". =20 Thanks in advance =20 Michel SALAIS ------=_NextPart_000_04F2_01DC2298.D5A50F50 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi all,

 

I could find several distinct values for column = “source” in pg_settings view. Examples of these values are: = client, environment variable, configuration file, default, database, = override, session.

Are there other values?

The documentation doesn’t = mention any thing (Any way I didn’t find).

In some of my databases, I have = this:

 

postgres# select name, source from = pg_settings where source like 'environ%';

      = name       = |       =  source       =

-----------------+----------------------

max_stack_depth | environment = variable

 

What is the meaning of = ‘environment_variable’ here?

For the other listed values, I have = “almost” got it but I don’t see anything for = “environment variable”.

 

Thanks in advance

 

Michel SALAIS

------=_NextPart_000_04F2_01DC2298.D5A50F50--