pg_reload_conf()

Поиск
Список
Период
Сортировка
От Marc Millas
Тема pg_reload_conf()
Дата
Msg-id CADX_1aaLOnPrCAi3xR1onuOfbtRwA25ORTsX+ZcLJc24SWs2bg@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_reload_conf()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: pg_reload_conf()  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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


Marc MILLAS
Senior Architect
+33607850334

В списке pgsql-general по дате отправления:

Предыдущее
От: Kirk Wolak
Дата:
Сообщение: Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_reload_conf()