On 1/9/24 09:38, Yi Sun wrote:
Hello,
We custom set variable
Added patroni.nodes_count = 2 in postgresql.conf
postgres=# show patroni.nodes_count;
patroni.nodes_count
---------------------
2
(1 row)
postgres=# select current_setting('patroni.nodes_count');
current_setting
-----------------
2
(1 row)
But can not select it from pg_settings, as we use pgwatch2 to monitor, to avoid pgwatch2 script change prefer to use pg_setting not current_setting() function, is it possible to get the custom variable from pg_setting please? Thanks
You may look into pg_file_settings :
select setting from pg_file_settings where name = 'patroni.nodes_count';