From: | Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | pg_reload_conf() |
Date: | 2023-02-20 16:57:34 |
Message-ID: | CADX_1aaLOnPrCAi3xR1onuOfbtRwA25ORTsX+ZcLJc24SWs2bg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
www.mokadb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2023-02-20 17:01:08 | Re: pg_reload_conf() |
Previous Message | Kirk Wolak | 2023-02-20 15:49:21 | Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5 |