On Wed, 2024-04-10 at 10:26 -0400, Tom Lane wrote:
> 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.
An alternative to looking at the log file is to
SELECT * FROM pg_file_settings WHERE error IS NOT NULL;
after you reload.
Yours,
Laurenz Albe
