的pg_hba.conf [英] pg_hba.conf
问题描述
您好，有时候当我尝试使用ssl连接到服务器时，我会从postgresql中收到一个奇怪的错误：
日志：parse_hba：语法无效在第46行的pg_hba.conf文件中，令牌
" hostssl"
详情
pg_hba.conf文件的内容是
hostssl dnet att 172.16.13.40 255.255.255.255 trust
谢谢
Angel T. Todorov
PGP公钥ID：1024D /
< http：// pgp.mit.edu:11371/pks/lookup?op=get&search=0x35454B4C> 35454B4C
Hello, sometimes I get a strange error from postgresql when I try to
connect using ssl to the server:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token
"hostssl"
FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for
details
The contents of the pg_hba.conf file are
hostssl dnet att 172.16.13.40 255.255.255.255 trust
thanks
Angel T. Todorov
PGP public key ID: 1024D/
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x35454B4C> 35454B4C
推荐答案
Angel Todorov写道：
Angel Todorov writes:
LOG：parse_hba：pg_hba.conf文件中的语法无效第46行，令牌
hostssl
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token
"hostssl"
看起来你的服务器没有使用SSL支持编译。
-
Peter Eisentraut pe*****@gmx.net
---------------------------（播出结束）------------ ---------------
提示8：解释分析是你的朋友
It looks as though your server was not compiled with SSL support.
--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
在2003年9月30日星期二，Angel Todorov写道：
On Tue, 30 Sep 2003, Angel Todorov wrote:
你好，有时当我尝试使用ssl连接到服务器时，我从postgresql收到一个奇怪的错误：
hostssl
致命：pg_hba.conf文件丢失或错误，请参阅postmaster日志中的
详情
pg_hba.conf文件的内容是
hostssl dnet att 172.16.13.40 255.255.255.255 trust
Hello, sometimes I get a strange error from postgresql when I try to
connect using ssl to the server:
LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token
"hostssl"
FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for
details
The contents of the pg_hba.conf file are
hostssl dnet att 172.16.13.40 255.255.255.255 trust
在7.3及更少的ssl连接失败如果主机线在hostssl
线之前匹配。至少我认为就是这种情况，即使在pg_hba中有一个
合适的条目，也会有一些ssl连接被拒绝的东西
。 conf
这相信在7.4中更合理。我相信。
-
Nigel J. Andrews
---------------------------（广播结束）---------------- -----------
提示7：别忘了增加免费空间地图设置
In 7.3 and less ssl connections fail if a host line matches before the hostssl
line. At least I think that''s the situation, there is definitely something
there that will make a ssl connection get rejected even if there is an
appropiate entry in pg_hba.conf
This works more sensibly in 7.4 I believe.
--
Nigel J. Andrews
---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings
" Nigel J. Andrews" < NA ****** @ investsystems.co.uk>写道：
"Nigel J. Andrews" <na******@investsystems.co.uk> writes:
在7.3中，如果主机行在hostssl
行之前匹配，则较少的ssl连接失败。至少我认为就是这种情况，即使在pg_hba.conf中有适当的条目
In 7.3 and less ssl connections fail if a host line matches before the hostssl
line. At least I think that''s the situation, there is definitely something
there that will make a ssl connection get rejected even if there is an
appropiate entry in pg_hba.conf
真的吗？你能举个例子吗？
问候，汤姆小巷
---------------- -----------（播出结束）---------------------------
提示1：订阅和取消订阅命令转至 ma*******@postgresql.org
Really? Can you show an example?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
这篇关于的pg_hba.conf的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
