Thanks Adrian,
the fact that the changes are visible only by the new backend, and NOT by
the backend which did the changes was what I did missed.
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Mon, Feb 20, 2023 at 6:01 PM Adrian Klaver
wrote:
> On 2/20/23 08:57, Marc Millas wrot
On Mon, Feb 20, 2023 at 9:57 AM Marc Millas wrote:
>
> select pg_reload_conf();
> t
>
> So, I am perplexed: what pg_reload_conf() is doing/not doing ?
>
It is sending a signal and stating success that said signal was sent.
David J.
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
-+--+-
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'
obviou
