PostgreSQL基础 include 额外的参数配置文件

CentOS 7.6.1810
postgresql 14.4

include 指定额外的参数配置文件

[postgres@localhost data]$ pwd
/var/lib/pgsql/14/data
[postgres@localhost data]$ ll | grep postgresql.conf
-rw-------. 1 postgres postgres 28770 Jul 12 20:42 postgresql.conf
[postgres@localhost data]$ vim postgresql.conf
复制

#------------------------------------------------------------------------------
# CONFIG FILE INCLUDES
#------------------------------------------------------------------------------

# These options allow settings to be loaded from files other than the
# default postgresql.conf.  Note that these are directives, not variable
# assignments, so they can usefully be given more than once.

#include_dir = '...'                    # include files ending in '.conf' from a directory, e.g., 'conf.d'
#include_if_exists = '...'              # include file only if it exists
#include = '...'                        # include file

复制

• include_dir：加载目录中，以".conf"结尾的参数文件
• include_if_exists：如果参数文件存在，则加载
• include：加载参数文件，不存在则报错

学习资料

• postgresql
• download-postgresql
• docs-postgresql
• db-engines
• 墨天轮社区

欢迎各位同学一起来交流学习心得！