Re: postgresql custom variable in pg_settings table

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