Postgres Pro
Downloads
Home   >   mailing lists

pg_reload_conf() - Mailing list pgsql-general

From Marc Millas
Subject pg_reload_conf()
Date
Msg-id CADX_1aaLOnPrCAi3xR1onuOfbtRwA25ORTsX+ZcLJc24SWs2bg@mail.gmail.com
Whole thread Raw
Responses Re: pg_reload_conf()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: pg_reload_conf()  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Kirk Wolak
Date:
Subject: Re: A performance issue in ROW_NUMBER() OVER(ORDER BY NULL) [27 times slow than OVER()] V14.5
Next
From: Adrian Klaver
Date:
Subject: Re: pg_reload_conf()