From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Lawrence Barwick <barwick@gmail.com>
cc: Matthias Apitz <guru@unixarea.de>, pgsql-general@lists.postgresql.org
Subject: Re: mystery with postgresql.auto.conf
In-reply-to: <CAB8KJ=jH9CRsX5r1-u1eVZ_FqMtWG=JdYMfBTfQwicATyEHVSw@mail.gmail.com>
References: <ZhZzfLUm2QtqOURc@pureos> <CAB8KJ=jtwkQ+a8UB7gtnMbvQeEWfgGmA9iOGdKFR9s11OSaBMg@mail.gmail.com> <ZhaIxarPqJXXwq4Q@pureos> <CAB8KJ=jH9CRsX5r1-u1eVZ_FqMtWG=JdYMfBTfQwicATyEHVSw@mail.gmail.com>
Comments: In-reply-to Ian Lawrence Barwick <barwick@gmail.com>
	message dated "Wed, 10 Apr 2024 21:49:49 +0900"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <4020595.1712759165.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 10 Apr 2024 10:26:05 -0400
Message-ID: <4020596.1712759165@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/4020596.1712759165%40sss.pgh.pa.us>
Precedence: bulk

Ian Lawrence Barwick <barwick@gmail.com> writes:
> 2024年4月10日(水) 21:40 Matthias Apitz <guru@unixarea.de>:
>> Why it does not give an error because the shared lib isn't there?

> ALTER SYSTEM is a way of modifying the PostgreSQL configuration file
> via SQL; just as when you modify it manually, changes are not applied
> until you actually reload the configuration.
> See: https://www.postgresql.org/docs/current/sql-altersystem.html

Even if you had issued a reload, you would not have noticed the
faulty setting without looking into the postmaster's log for
warning messages.  The system wouldn't get in your face about it
until you did a postmaster restart.

			regards, tom lane