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) |