Re: mystery with postgresql.auto.conf
Tom Lane <tgl@sss.pgh.pa.us>
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
Date: 2024-04-10T14:26:05Z
Lists: pgsql-general
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