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';
Best Regards SY
