postgresql custom variable in pg_settings table - Mailing list pgsql-general

From Yi Sun
Subject postgresql custom variable in pg_settings table
Date
Msg-id CABWY_HCPQ6c65aBPHSHMXg43SACBxWOd9Vq8Wyut7hGy6Y1qHw@mail.gmail.com
Whole thread Raw
Responses Re: postgresql custom variable in pg_settings table  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
Re: postgresql custom variable in pg_settings table  (jian he <jian.universality@gmail.com>)
List pgsql-general
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

Best Regards
SY

pgsql-general by date:

Previous
From:
Date:
Subject: Make NUM_XLOGINSERT_LOCKS configurable
Next
From: Achilleas Mantzios - cloud
Date:
Subject: Re: postgresql custom variable in pg_settings table