Re: pg_reload_conf()

On 2/20/23 08:57, Marc Millas wrote:
> select  setting, boot_val, reset_val from pg_settings where 
> name='log_connections';

# select  setting, boot_val, reset_val, context from pg_settings where 
name='log_connections';
  setting | boot_val | reset_val |      context
---------+----------+-----------+-------------------
  on      | off      | on        | superuser-backend


https://www.postgresql.org/docs/15/view-pg-settings.html

There are several possible values of context. In order of decreasing 
difficulty of changing the setting, they are:


...

superuser-backend

     Changes to these settings can be made in postgresql.conf without 
restarting the server. They can also be set for a particular session in 
the connection request packet (for example, via libpq's PGOPTIONS 
environment variable), but only if the connecting user is a superuser or 
has been granted the appropriate SET privilege. However, these settings 
never change in a session after it is started. If you change them in 
postgresql.conf, send a SIGHUP signal to the postmaster to cause it to 
re-read postgresql.conf. The new values will only affect 
subsequently-launched sessions.

...
-- 
Adrian Klaver
adrian.klaver@aklaver.com