Re: mystery with postgresql.auto.conf - Mailing list pgsql-general

From Tom Lane
Subject Re: mystery with postgresql.auto.conf
Date
Msg-id 4020596.1712759165@sss.pgh.pa.us
Whole thread Raw
In response to Re: mystery with postgresql.auto.conf  (Ian Lawrence Barwick <barwick@gmail.com>)
Responses Re: mystery with postgresql.auto.conf  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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



pgsql-general by date:

Previous
From: Francisco Prado
Date:
Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs
Next
From: Laurenz Albe
Date:
Subject: Re: mystery with postgresql.auto.conf