| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
| Cc: | Matthias Apitz <guru(at)unixarea(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: mystery with postgresql.auto.conf |
| Date: | 2024-04-10 14:26:05 |
| Message-ID: | 4020596.1712759165@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ian Lawrence Barwick <barwick(at)gmail(dot)com> writes:
> 2024年4月10日(水) 21:40 Matthias Apitz <guru(at)unixarea(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-04-10 14:33:50 | Re: mystery with postgresql.auto.conf |
| Previous Message | Francisco Prado | 2024-04-10 13:38:07 | Re: Some advice need after a 20 year gap after Ingres/GUIs |