PostgreSQL Configuration File Locations

UPDATED ON: Apr 29, 2020

The following commands are run inside psql. SHOW is used to display the current setting of run-time parameters.

config_file

db=# SHOW config_file;
  • location of the main server configuration file
  • usually called postgresql.conf

hba_file

db=# SHOW hba_file;
  • location of the configuration file for host-based authentication
  • usually called pg_hba.conf

ident_file

db=# SHOW ident_file;
  • location of the configuration file for user name mapping
  • usually called pg_ident.conf

Links