DBA Hub

📋Steps in this guide1/1

Find location of postgres conf files

Find location of postgres related conf files

postgresql configurationintermediate
by PostgreSQL
13 views
1

Find location of postgres conf files

Find location of postgres related conf files alternatively:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
dbaclass=#
SELECT name, setting FROM pg_settings WHERE category = 'File Locations';
name                     | setting
-------------------+---------------------------------------------
config_file              | /Library/PostgreSQL/10/data/postgresql.conf
data_directory           | /Library/PostgreSQL/10/data
external_pid_file        |
hba_file                 | /Library/PostgreSQL/10/data/pg_hba.conf
ident_file               | /Library/PostgreSQL/10/data/pg_ident.conf
(5 rows)
postgres=#
show config_file
;
config_file
--------------------------------------------
/Library/PostgreSQL/10/data/postgresql.conf
(1 row)
postgres=#
show hba_file;
hba_file
-----------------------------------------
/Library/PostgreSQL/10/data/pg_hba.conf
(1 row)
postgres=#
show ident_file;
ident_file
-------------------------------------------
/Library/PostgreSQL/10/data/pg_ident.conf
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!