PG参数文件位置

jiawang

查看参数文件位置
show config_file ;
show hba_file ;
show ident_file ;


也可以用pg_settings数据字典来查看
postgres=# select name,setting from pg_settings where category= 'File Locations';
name | setting
-------------------+--------------------------------------
config_file | /u01/postgresql/data/postgresql.conf
data_directory | /u01/postgresql/data
external_pid_file |
hba_file | /u01/postgresql/data/pg_hba.conf
ident_file | /u01/postgresql/data/pg_ident.conf
(5 rows)