blocks|key|1156211|text|或者询问你的数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156212|$+psql+-U+postgres+-c+'SHOW+config_file'|code-block|syntax|javascript|1156213|或者，如果以ubuntu用户身份登录：|offset|length|style|CODE|1156214|$+sudo+-u+postgres+psql+-c+'SHOW+config_file'|1156215|entityMap^0|0|0|6|6|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Or ask your database:
<pre><code>$ psql -U postgres -c 'SHOW config_file'
</code></pre>
or, if logged in as the <code>ubuntu</code> user:
<pre><code>$ sudo -u postgres psql -c 'SHOW config_file'
</code></pre>

blocks|key|942083|text|使用软件中心安装的Ubuntu+13.04：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|942084|我的位置是：|942085|/etc/postgresql/9.1/main/postgresql.conf|code-block|syntax|javascript|942086|entityMap^0|9|C|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

<code>Ubuntu 13.04</code> installed using software centre :

The location for mine is:

<pre><code>/etc/postgresql/9.1/main/postgresql.conf
</code></pre>

blocks|key|942052|text|跑|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942053|sudo+updatedb|code-block|syntax|javascript|942054|紧接着是|942055|locate+postgresql.conf|942056|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Run

<pre><code>sudo updatedb
</code></pre>

followed by

<pre><code>locate postgresql.conf
</code></pre>

blocks|key|1156518|text|要获得pg_hba.conf文件的位置，还可以查询数据库，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156519|SHOW+hba_file;|code-block|syntax|javascript|1156520|你应该得到像这样的东西|1156521|++++++++++++hba_file+++++++++++++
---------------------------------
+/var/lib/pgsql/data/pg_hba.conf
(1+row)|1156522|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

To get the location of the pg_hba.conf file, you can also query the database like

<pre><code>SHOW hba_file;
</code></pre>

You should get something like

<pre><code> hba_file 
---------------------------------
 /var/lib/pgsql/data/pg_hba.conf
(1 row)
</code></pre>

blocks|key|1156341|text|在Mac上(使用brew安装Postgres)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156342|/usr/local/Cellar/postgresql/9.3.3>bin/postgres+-D+/usr/local/var/postgres/|code-block|syntax|javascript|1156343|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On Mac (Postgres installed using brew) :

<pre><code>/usr/local/Cellar/postgresql/9.3.3&gt;bin/postgres -D /usr/local/var/postgres/
</code></pre>

blocks|key|942718|text|如果你刚刚安装了它，locate可能帮不上忙。在这种情况下，服务应处于运行状态，您可以运行|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|942719|ps+aux++%7C+grep+'postgres+*-D'|code-block|syntax|javascript|942720|来查看postgresql-master从何处加载配置文件。|942721|entityMap^0|A|6|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If you have just installed it, it is possible that <code>locate</code> doesn't help. In that case, the service should be running and you can run

<pre><code>ps aux | grep 'postgres *-D'
</code></pre>

to see where the postgresql-master is loading the config files from.

blocks|key|1157024|text|打印pg_hba.conf文件位置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1157025|su+-+postgres+-c+"psql+-t+-P+format=unaligned+-c+'show+hba_file';"|code-block|syntax|javascript|1157026|打印postgresql.conf文件位置：|1157027|su+-+postgres+-c+"psql+-t+-P+format=unaligned+-c+'SHOW+config_file';"|1157028|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Print pg_hba.conf file location:

<pre><code>su - postgres -c "psql -t -P format=unaligned -c 'show hba_file';"
</code></pre>

Print postgresql.conf file location:

<pre><code>su - postgres -c "psql -t -P format=unaligned -c 'SHOW config_file';"
</code></pre>

blocks|key|942183|text|在Fedora+20上|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942184|$+cd+/var/lib/pgsql/data
$+ls+-ltr+*.conf

-rw-------.+1+postgres+postgres+20453+Jan+18+23:22+postgresql.conf
-rw-------.+1+postgres+postgres++1636+Jan+18+23:22+pg_ident.conf
-rw-------.+1+postgres+postgres++4476+Jan+18+23:22+pg_hba.conf|code-block|syntax|javascript|942185|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On Fedora 20

<pre><code>$ cd /var/lib/pgsql/data
$ ls -ltr *.conf

-rw-------. 1 postgres postgres 20453 Jan 18 23:22 postgresql.conf
-rw-------. 1 postgres postgres 1636 Jan 18 23:22 pg_ident.conf
-rw-------. 1 postgres postgres 4476 Jan 18 23:22 pg_hba.conf
</code></pre>

blocks|key|1156418|text|对于CentOS+6和7以及PostgreSQL9.2(以及更低版本，我猜可能也是Fedora和Redhat+)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156419|/var/lib/pgsql/data|offset|length|style|CODE|1156420|对于CentOS+6和7+PostgreSQL9.3或9.4+(以及更高版本，我认为)：|1156421|/var/lib/pgsql/9.3/data
/var/lib/pgsql/9.4/data|code-block|syntax|javascript|1156422|对于Ubuntu+14和postgresql+9.3：|1156423|/etc/postgresql/9.3/main/postgresql.conf|1156424|entityMap^0|0|0|J|0|0|0|0|0|14|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|Z|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

For CentOS 6 and 7 and postgresql 9.2 (and below, I suppose, possibly Fedora and Redhat as well):

<code>/var/lib/pgsql/data</code>

For CentOS 6 and 7 postgresql 9.3 or 9.4 (and above, I suppose):

<pre><code>/var/lib/pgsql/9.3/data
/var/lib/pgsql/9.4/data
</code></pre>

For Ubuntu 14 and postgresql 9.3: 

<code>/etc/postgresql/9.3/main/postgresql.conf</code>

blocks|key|1156555|text|答案可能是您还没有初始化数据库。在安装postgres之后，但在初始化数据库之前，postgres*.sql文件将不存在。初始化数据库后，将出现postgres*.sql文件。(Centos+6，Postgres+9.3在此演示)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156556|[root@localhost+/]#+yum+-y+install+postgresql93+postgresql93-server+
[root@localhost+/]#+ls+/var/lib/pgsql/9.3/data/
[root@localhost+/]#
[root@localhost+/]#+service+postgresql-9.3+initdb
Initializing+database:+++++++++++++++++++++++++++++++++++++[++OK++]
[root@localhost+/]#+ls+/var/lib/pgsql/9.3/data/
base+++++++++pg_ident.conf++pg_serial+++++pg_subtrans++pg_xlog
global+++++++pg_log+++++++++pg_snapshots++pg_tblspc++++postgresql.conf
pg_clog++++++pg_multixact+++pg_stat+++++++pg_twophase
pg_hba.conf++pg_notify++++++pg_stat_tmp+++PG_VERSION
[root@localhost+/]#|code-block|syntax|javascript|1156557|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The answer may be that you have not initialized the database yet. After installing postgres, but before initializing the database, the postgres*.sql files will be absent. After initializing the database the postgres*.sql files will appear. (Centos 6, Postgres 9.3 demonstrated here)

<pre><code>[root@localhost /]# yum -y install postgresql93 postgresql93-server 
[root@localhost /]# ls /var/lib/pgsql/9.3/data/
[root@localhost /]#
[root@localhost /]# service postgresql-9.3 initdb
Initializing database: [ OK ]
[root@localhost /]# ls /var/lib/pgsql/9.3/data/
base pg_ident.conf pg_serial pg_subtrans pg_xlog
global pg_log pg_snapshots pg_tblspc postgresql.conf
pg_clog pg_multixact pg_stat pg_twophase
pg_hba.conf pg_notify pg_stat_tmp PG_VERSION
[root@localhost /]#
</code></pre>

blocks|key|942652|text|在Mac+OS+X上：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942653|sudo+find+/+-name+postgresql.conf+|code-block|syntax|javascript|942654|您可以通过以下命令查找其他conf文件：|942655|sudo+find+/+-name+pg\*.conf|942656|注:参见使用man的用法：|942657|man+find|942658|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

On Mac OS X:

<pre><code>sudo find / -name postgresql.conf 
</code></pre>

You can find other conf files by the following command:

<pre><code>sudo find / -name pg\*.conf
</code></pre>

Note: See usage using man:

<pre><code>man find
</code></pre>

blocks|key|1156622|text|由于我无法访问postgres帐户(因此无法运行SHOW+config_file)，并且我的postgres安装在Windows上，因此没有一个答案对我有所帮助，所以我将我的文件位置分享给未来的Windows读者：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1156623|C:\Program+Files\PostgreSQL\9.5\data|1156624|entityMap^0|O|G|0|0|10|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

As I don't have access to postgres account (so can't run <code>SHOW config_file</code>) and my postgres is installed on Windows, none of the answers helped me, so I'm sharing my file location for future Windows readers:

<code>C:\Program Files\PostgreSQL\9.5\data</code>

blocks|key|1156673|text|除了the+direct+answer，你可能还想看看the+docs+about+Postgres+config+file+locations。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1156674|在大多数情况下:在$PGDATA下，通常是/var/lib/postgresql/data或类似的路径(如果使用Docker+images，至少是默认路径)。|style|CODE|1156675|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/3603162/1468388|1|https://www.postgresql.org/docs/current/static/runtime-config-file-locations.html|2|https://hub.docker.com/_/postgres/^0|2|H|0|R|19|1|0|9|7|L|O|1K|D|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]|$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@$A|11|B|12|F|G]|$A|13|B|14|F|G]]|9|@$A|15|B|16|1|17]]|C|$]]|$1|H|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]]]

Besides <a href="https://stackoverflow.com/a/3603162/1468388">the direct answer</a>, you will probably want to check out <a href="https://www.postgresql.org/docs/current/static/runtime-config-file-locations.html" rel="nofollow noreferrer">the docs about Postgres config file locations</a>.

In most cases: under <code>$PGDATA</code>, which is normally <code>/var/lib/postgresql/data</code> or something similar (at least it's the default path if you use <a href="https://hub.docker.com/_/postgres/" rel="nofollow noreferrer">Docker images</a>).

blocks|key|942595|text|对于Debian+9，我使用Franke+Heikens+answer+-$+/etc/postgresql/9.6/main/postgresql.conf找到了我的答案|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942596|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For Debian 9 I found mine using Franke Heikens answer - $ /etc/postgresql/9.6/main/postgresql.conf

blocks|key|1156469|text|在装有PostgreSQL+9.4的CentOS+7中，它位于以下目录中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1156470|/var/lib/pgsql/9.4/data|code-block|syntax|javascript|1156471|当我以root身份登录时，我可以看到它。|1156472|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In CentOS 7 with PostgreSQL 9.4 it's in the following directory: 

<pre><code>/var/lib/pgsql/9.4/data
</code></pre>

I can see it when I'm logged in as root.

blocks|key|942784|text|nantha=#显示config_file；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942785|config_file|942786|/var/lib/postgresql/data/postgresql.conf+(1行)|942787|nantha=#显示hba_file；|942788|hba_file|942789|/var/lib/postgresql/data/pg_hba.conf+(1行)|942790|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

nantha=# SHOW config_file;

<h2> config_file</h2>

/var/lib/postgresql/data/postgresql.conf
(1 row)

nantha=# SHOW hba_file;

<h2> hba_file</h2>

/var/lib/postgresql/data/pg_hba.conf
(1 row)

blocks|key|1156986|text|在我使用brew+install+postgresql安装的MacOS+Mojave上，我在这里找到了它|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1156987|/usr/local/var/postgres/postgresql.conf|1156988|我使用下面的this响应中引用的sql命令得到了这个结果：|1156989|psql+-U+postgres+-c+'SHOW+config_file'|1156990|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/3603162/2668545^0|4|N|0|0|13|0|6|4|0|0|0|12|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|Z|8|@]|D|@$9|10|A|11|1|12]]|E|$]]|$1|J|3|K|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S]]]]

on MacOS Mojave where I used <code>brew install postgresql</code> to install, I found it here

<code>/usr/local/var/postgres/postgresql.conf</code>

I got this using the following sql command cited in <a href="https://stackoverflow.com/a/3603162/2668545">this</a> response here: 

<code>psql -U postgres -c 'SHOW config_file'</code>

blocks|key|1157079|text|Win7，版本10位置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1157080|C:\Program+Files\PostgreSQL\10\postgresql.conf|code-block|syntax|javascript|1157081|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Win7, version 10 location:

<pre><code>C:\Program Files\PostgreSQL\10\postgresql.conf
</code></pre>

blocks|key|943101|text|如果您在docker容器中有postgres，那么您可能正在绑定.conf文件，要查找您在docker外部使用的.conf文件，请运行docker+inspect+postgres11或postgres容器名称或id。该命令返回一个json，查找类似于|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|943102|"HostConfig":+{
++++++++++++"Binds":+[
++++++++++++++++"/home/my_user/postgres11/:/var/lib/postgresql/data"
++++++++++++]|code-block|syntax|javascript|943103|如果执行SHOW+config_file;并且结果在/var/lib/postgresql/data/postgresql.conf中，那么您就知道外部的.conf文件在/home/my_user/postgres11/postgresql.conf中，或者在属性"Binds“中得到的结果。|943104|entityMap^0|1V|P|0|0|4|H|Q|14|2D|14|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

If you have the postgres in a docker container, probably you are binding the .conf file, to find the .conf file you are using outside the docker, run <code>docker inspect postgres11</code> or the postgres container name or id. That command returns a json, look for somethig like
<pre><code>&quot;HostConfig&quot;: {
 &quot;Binds&quot;: [
 &quot;/home/my_user/postgres11/:/var/lib/postgresql/data&quot;
 ]
</code></pre>
If you execute <code>SHOW config_file;</code> and the result is in <code>/var/lib/postgresql/data/postgresql.conf</code> then you know the .conf file outside is in <code>/home/my_user/postgres11/postgresql.conf</code>, or the resulted in the property &quot;Binds&quot;

blocks|key|943140|text|我在这里找到它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|943141|/var/lib/pgsql/9.6/data/postgresql.conf|code-block|syntax|javascript|943142|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I located it here:
<pre><code>/var/lib/pgsql/9.6/data/postgresql.conf
</code></pre>

blocks|key|942133|text|如果您遵循了亚马逊发布的在亚马逊网站上安装Postgresql的白皮书，其中包括在装载在单独EBS卷上的文件系统上创建/+postgresql.conf+/目录，那么您的数据文件位于/data/中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|942134|由此我得出结论，该文件是在数据目录初始化期间创建的，并且驻留在数据目录的根目录中。对于默认安装，它显示为/var/lib/pgsql/+data，但如果您移动了数据目录，则不是这样|942135|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you followed the white paper put out by Amazon for installing Postgresql on AWS, which included creating a /data/ directory on a filesystem mounted on a separate EBS volume, then your postgresql.conf file is in /data/

From which I conclude the file is created during initialisation of the data directory, and resides in the root of the data dir. For a default install this appears to be /var/lib/pgsql/data, but not if you moved the data dir

blocks|key|943033|text|对于ubuntu+18/20，请执行以下命令来定位您的postgresql.conf文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|943034|locate+postgresql.conf|code-block|syntax|javascript|943035|如果您的linux中缺少locate，那么首先运行sudo+apt-get+install+locate来安装locate。|offset|length|style|CODE|943036|entityMap^0|0|0|P|R|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For ubuntu 18/20, run the following command to locate your postgresql.conf file:
<pre><code>locate postgresql.conf
</code></pre>
If locate is missing in your linux then run <code>sudo apt-get install locate</code> to install locate first.

blocks|key|943159|text|在ubuntu中，您可以找到|type|unstyled|depth|inlineStyleRanges|entityRanges|data|943160|/etc/postgresql/11/main/pg_hba.conf

//+after+change+restart+it+otherwise+it+won't+be+work

service+postgresql+restart|code-block|syntax|javascript|943161|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In ubuntu, you can find
<pre><code>/etc/postgresql/11/main/pg_hba.conf

// after change restart it otherwise it won't be work

service postgresql restart
</code></pre>

I have recently installed PostgreSQL on Ubuntu with the EnterpriseDB package. I can connect to the database locally, but I can't configure it because I can't find config files. I searched through entire hard drive and found only samples like <code>pg_hba.conf.sample</code>
Where are the PostgreSQL <code>.conf</code> files?

Where does PostgreSQL store configuration/conf files?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我最近在Ubuntu上用EnterpriseDB包安装了PostgreSQL。我可以在本地连接到数据库，但我无法对其进行配置，因为我找不到配置文件。我搜索了整个硬盘，只找到了像pg_hba.conf.sample这样的样本PostgreSQL .conf文件在哪里？

问PostgreSQL将配置/conf文件存储在哪里？
EN

回答 23

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PostgreSQL将配置/conf文件存储在哪里？EN

回答 23

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PostgreSQL将配置/conf文件存储在哪里？
EN