[pgpool-hackers: 4010] Proposal: use include in pgpool.conf

Tatsuo Ishii ishii at sraoss.co.jp
Wed Sep 1 15:52:27 JST 2021


Now that Hoshiai-san has implemented "include" feature in pgpool.conf,
I would like to propose to reduce the size of pgpool.conf by using the
"include" feature. The idea is simple: just move some of parameters in
pgpool.conf to separate files. For example, instead of having watchdog
parameters in pgpool.conf, move them to "watchdog.conf" and replaces
those parameters in pgpool.conf by just:

include = 'watchdog.conf'

This not only reduces the size of pgpool.conf (which is good for
users) but makes those common parameters be moved to single file and
be shared by multiple pgpool.conf files, which should make developers'
life easier, because they don't need to update parameters in multiple
files.

Attached is the PoC patch. Only pgpool.conf.sample-stream is
modified. The patch adds auth.conf, health_check.conf,
load_balance.conf, log.conf, query_cache.conf, ssl.conf and
watchdog.conf as the shared common configuration files (you should be
able to guess which file is for which parameters from their file
names). You may want to add even more files.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_conf_include.diff
Type: text/x-patch
Size: 61577 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20210901/15802523/attachment-0001.bin>


More information about the pgpool-hackers mailing list