Re: postgresql custom variable in pg_settings table

[Achilleas Mantzios - cloud <a.mantzios@xxxxxxxxxxxxxxxxxxxx>]

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