blocks|key|1197320|text|只需使用0.0.0.0/0即可。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1197321|host++++all+++++++++++++all+++++++++++++0.0.0.0/0++++++++++++md5|code-block|syntax|javascript|1197322|确保postgresql.conf+(或ALTER+SYSTEM+SET)中的listen_addresses允许所有可用IP接口上的传入连接。|1197323|listen_addresses+=+'*'|1197324|更改之后，您必须重新加载配置。为此，一种方法是以超级用户身份执行此SELECT。|1197325|SELECT+pg_reload_conf();|1197326|注意:要更改listen_addresses，重新加载是不够的，您必须重新启动服务器。|1197327|entityMap|0|LINK|mutability|MUTABLE|url|https://www.postgresql.org/docs/current/static/sql-altersystem.html|1|https://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-LISTEN-ADDRESSES^0|4|9|0|0|2|F|K|G|13|G|K|G|0|13|G|1|0|0|X|6|0|0|6|G|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@$9|1F|A|1G|1|1H]|$9|1I|A|1J|1|1K]]|E|$]]|$1|M|3|N|5|H|7|1L|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1M|8|@$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1P|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1Q|8|@$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]|12|$5|X|Y|Z|E|$10|13]]]]

Just use <code>0.0.0.0/0</code>.
<pre class="lang-none prettyprint-override"><code>host all all 0.0.0.0/0 md5
</code></pre>
Make sure the <a href="https://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-LISTEN-ADDRESSES" rel="noreferrer"><code>listen_addresses</code></a> in <code>postgresql.conf</code> (or <a href="https://www.postgresql.org/docs/current/static/sql-altersystem.html" rel="noreferrer"><code>ALTER SYSTEM SET</code></a>) allows incoming connections on all available IP interfaces.
<pre class="lang-none prettyprint-override"><code>listen_addresses = '*'
</code></pre>
After the changes you have to reload the configuration. One way to do this is execute this <code>SELECT</code> as a superuser.
<pre class="lang-sql prettyprint-override"><code>SELECT pg_reload_conf();
</code></pre>
Note: to change <code>listen_addresses</code>, a reload is not enough, and you have to restart the server.

blocks|key|1197362|text|所有IPv4地址的0.0.0.0/0|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1197363|所有IPv6地址的::0/0|1197364|匹配任何IP地址的all|1197365|匹配任何服务器自己的IP地址的samehost|1197366|匹配服务器直接连接到的任何子网中的任何地址的samenet。|1197367|例如：|1197368|host++++all+++++++++++++all+++++++++++++0.0.0.0/0++++++++++++md5|code-block|syntax|javascript|1197369|entityMap^0|9|9|0|9|5|0|9|3|0|F|8|0|M|7|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1B|8|@]|D|@]|E|$]]|$1|P|3|Q|5|R|7|1C|8|@]|D|@]|E|$S|T]]|$1|U|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|V|$]]

<code>0.0.0.0/0</code> for all IPv4 addresses

<code>::0/0</code> for all IPv6 addresses

<code>all</code> to match any IP address 

<code>samehost</code> to match any of the server's own IP addresses

<code>samenet</code> to match any address in any subnet that the server is directly connected to.

e.g.

<pre><code>host all all 0.0.0.0/0 md5
</code></pre>

blocks|key|982876|text|除了上述很好的答案，如果你想要某个范围的if被授权，你可以编辑/var/lib/pgsql/{VERSION}/data文件并放入如下内容|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|982877|host++++all+++++++++++++all+++++++++++++172.0.0.0/8++++++++trust|982878|它将接受来自上述范围内任何主机的传入连接。来源：http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/c15679_002.htm|982879|entityMap|0|LINK|mutability|MUTABLE|url|http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/c15679_002.htm^0|V|T|0|0|1S|0|O|2R|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|J|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

Addition to above great answers, if you want some range of IPs to be authorized, you could edit <code>/var/lib/pgsql/{VERSION}/data</code> file and put something like 

<code>host all all 172.0.0.0/8 trust</code>

It will accept incoming connections from any host of the above range.
Source: <a href="http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/c15679_002.htm" rel="noreferrer">http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/c15679_002.htm</a>

I've got a PostgreSQL data base that I'd like to configure to accept all incoming connections regardless of the source IP address. How can this be configured in the pg_hba.conf file? I'm using postgreSQL version 8.4.

How to configure PostgreSQL to accept all incoming connections

SQL数据库

PostgreSQL

数据库

服务器

我有一个PostgreSQL数据库，我想将其配置为接受所有传入连接，而不管源IP地址是什么。如何在pg_hba.conf文件中对其进行配置？我使用的是postgreSQL版本8.4。

问如何配置PostgreSQL以接受所有传入连接
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何配置PostgreSQL以接受所有传入连接EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何配置PostgreSQL以接受所有传入连接
EN