From: | Bill Chandler <billybobc1210(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Missing or errooneous pg_hba.conf file |
Date: | 2004-05-19 20:28:34 |
Message-ID: | 20040519202834.15105.qmail@web12903.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)yahoo(dot)com
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-19 21:16:26 | Re: Missing or errooneous pg_hba.conf file |
Previous Message | admin | 2004-05-19 20:11:25 | postgresql not using enough memory? |