Missing or errooneous pg_hba.conf file
От | Bill Chandler |
---|---|
Тема | Missing or errooneous pg_hba.conf file |
Дата | |
Msg-id | 20040519202834.15105.qmail@web12903.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: Missing or errooneous pg_hba.conf file
|
Список | pgsql-admin |
Hello, Running 7.4.2 on Solaris 8 (binaries were built on a different Solaris 8 box). I keep getting the following message when trying to connect to server: FATAL: missing or erroneous pg_hba.conf file HINT: see server log for details. Server log contains message: LOG: invalid entry in pg_hba.conf file at line 60, token "255.255.255.255" The only change I've made was to postgresql.conf to change "tcpip_socket = true". I have not modified pg_hba.conf at all. Line 60 is the default 'host' entry for 127.0.0.1. The token in question is the IP-MASK field. I have found that if I change this value to anything other than "255.255.255.255" (e.g. "255.255.255.254") the message goes away. I get the same message if I add other lines with IP-MASK=255.255.255.255 to the pg_hba.conf file. It just doesn't seem to like '255.255.255.255' for some reason. I get the error using both the 'psql -h ...' command and trying to connect via JDBC. Incidentally, I saw the same problem running in 7.4.1. I ended up just commenting out line 60 to get around it. But now I need IP-MASK=255.255.255.255 so I need to get it resolved. Interestingly the same 7.4.1 binary running on a different machine did not exhibit the problem. Could it be a Solaris patch level thing? thanks in advance, Bill billybobc1210@yahoo.com __________________________________ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/
В списке pgsql-admin по дате отправления: