pg_reload_conf()
От | Marc Millas |
---|---|
Тема | pg_reload_conf() |
Дата | |
Msg-id | CADX_1aaLOnPrCAi3xR1onuOfbtRwA25ORTsX+ZcLJc24SWs2bg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pg_reload_conf()
Re: pg_reload_conf() |
Список | pgsql-general |
Hi,
maybe I am missing something...
with superuser rights, on a postgres 14 and postgres 15 version:
select setting, boot_val, reset_val from pg_settings where name='log_connections';
off off off
alter system set log_connections to 'on';
select setting, boot_val, reset_val from pg_settings where name='log_connections';
off off off
... strange
select pg_reload_conf();
t
select setting, boot_val, reset_val from pg_settings where name='log_connections';
off off off
very strange.
cat postgresql.auto.conf
log_connections = 'on'
obviously, if I stop and restart the DB,
select setting, boot_val, reset_val from pg_settings where name='log_connections';
on off on
So, I am perplexed: what pg_reload_conf() is doing/not doing ?
thanks
В списке pgsql-general по дате отправления: