On Tue, Jan 9, 2024 at 3:38 PM Yi Sun wrote:
>
> Hello,
>
>
>
> 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?
>
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
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 i
