Locating the PostgreSQL configuration files - Perceptive Content Database Install Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database Install Guide

Platform
Perceptive Content
Product
Perceptive Content Database Install Guide
Release
Foundation 24.1
License

By default the pg_hba.conf and postgresql.conf files are located in the data directory of the database cluster ($PGDATA). To locate the PostgreSQL configuration files, complete any of the following actions.

Command Scope
show hba_file;
show config_file;
select name, setting from
pg_settings where category = 'File
Locations';
Connected to the database with the postgres role
$ psql -U postgres -d postgres -c
"show hba_file"
$ psql -U postgres -d postgres -c
"show config_file"
Execute the command from the OS command line
Go to Tools then Server
Configuration to view and change
settings
pgAdmin III (Native GUI interface)