Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1m5khI-0005OG-ES
	for pgsql-admin@arkaria.postgresql.org; Tue, 20 Jul 2021 08:01:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1m5khH-0002mu-AJ
	for pgsql-admin@arkaria.postgresql.org; Tue, 20 Jul 2021 08:01:47 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <holger@jakobs.com>)
	id 1m5khH-0002mm-1S
	for pgsql-admin@lists.postgresql.org; Tue, 20 Jul 2021 08:01:47 +0000
Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de)
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <holger@jakobs.com>)
	id 1m5khE-000153-I9
	for pgsql-admin@lists.postgresql.org; Tue, 20 Jul 2021 08:01:46 +0000
Received: from localhost (localhost [127.0.0.1])
	by rs.plausibolo.de (Postfix) with ESMTP id 0A2F8380430;
	Tue, 20 Jul 2021 10:01:43 +0200 (CEST)
Received: from rs.plausibolo.de ([IPv6:::1])
	by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024)
	with ESMTP id ZxetPqOL7jKL; Tue, 20 Jul 2021 10:01:42 +0200 (CEST)
Received: from tuxedo.local.de (ip-37-201-154-229.hsi13.unitymediagroup.de
 [37.201.154.229])
	by rs.plausibolo.de (Postfix) with ESMTPSA id B433138035E;
	Tue, 20 Jul 2021 10:01:42 +0200 (CEST)
Subject: Re: postgresql.auto.conf
To: pgsql-admin@lists.postgresql.org
References: 
 <CALhHtcDXTTSknHN2i1mTCz4xMaiLcL-bpqOUBb56PruyZxUX-Q@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <9d384d8e-7e70-10a2-0888-10da15253665@jakobs.com>
Date: Tue, 20 Jul 2021 10:01:41 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: 
 <CALhHtcDXTTSknHN2i1mTCz4xMaiLcL-bpqOUBb56PruyZxUX-Q@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="j5d1fMvB6ae1ymhZv3lqgtFQhsN0h7ZqJ"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/9d384d8e-7e70-10a2-0888-10da15253665%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--j5d1fMvB6ae1ymhZv3lqgtFQhsN0h7ZqJ
Content-Type: multipart/mixed; boundary="wkFnK55tdr5BOt7EsISFSWdGhoEx48Ato";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <9d384d8e-7e70-10a2-0888-10da15253665@jakobs.com>
Subject: Re: postgresql.auto.conf
References: <CALhHtcDXTTSknHN2i1mTCz4xMaiLcL-bpqOUBb56PruyZxUX-Q@mail.gmail.com>
In-Reply-To: <CALhHtcDXTTSknHN2i1mTCz4xMaiLcL-bpqOUBb56PruyZxUX-Q@mail.gmail.com>

--wkFnK55tdr5BOt7EsISFSWdGhoEx48Ato
Content-Type: multipart/alternative;
 boundary="------------77B0A8D688C554A541A5DFD1"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------77B0A8D688C554A541A5DFD1
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

This information can be very easily found in the documentation.

Please read first before asking on this list.

https://www.postgresql.org/docs/current/config-setting.html#CONFIG-INCLUD=
ES

Am 20.07.21 um 09:08 schrieb Yambu:
> Hello
>
> May I please know if the settings set by the *alter system set=20
> *command, take precedence over all settings in other configuration=20
> files? even after restart they are not lost
>
> regards

--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------77B0A8D688C554A541A5DFD1
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>This information can be very easily found in the documentation.</p=
>
    <p>Please read first before asking on this list.</p>
    <p><a class=3D"moz-txt-link-freetext" href=3D"https://www.postgresql.=
org/docs/current/config-setting.html#CONFIG-INCLUDES">https://www.postgre=
sql.org/docs/current/config-setting.html#CONFIG-INCLUDES</a><br>
    </p>
    <div class=3D"moz-cite-prefix">Am 20.07.21 um 09:08 schrieb Yambu:<br=
>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CALhHtcDXTTSknHN2i1mTCz4xMaiLcL-bpqOUBb56PruyZxUX-Q@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Hello<br>
        <div><br>
        </div>
        <div>May I please know if the settings set by the <b>alter
            system set=C2=A0 </b>command, take precedence over all settin=
gs
          in other configuration files? even after restart they are not
          lost</div>
        <div><br>
        </div>
        <div>regards</div>
      </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------77B0A8D688C554A541A5DFD1--

--wkFnK55tdr5BOt7EsISFSWdGhoEx48Ato--

--j5d1fMvB6ae1ymhZv3lqgtFQhsN0h7ZqJ
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYPaC5QUDAAAAAAAKCRCKV5yTsxlhumR6
AKCSYRZrPDymLOJsZ1oQd0sr5ynEdQCgkHCsrwJvWxHqD7fHBYYOFq7vhnU=
=PcfP
-----END PGP SIGNATURE-----

--j5d1fMvB6ae1ymhZv3lqgtFQhsN0h7ZqJ--