[HACKERS] 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks

[Oliver Jowett]

8.0.0beta1 tarball built with gcc 3.2.3 under Solaris 9 on a E250 
(ultrasparc). I see the same bug as described in 
http://archives.postgresql.org/pgsql-admin/2004-05/msg00248.php: a mask 
of 255.255.255.255 in pg_hba.conf is rejected with

LOG:  invalid IP mask "255.255.255.255" in pg_hba.conf file line 65: host/servname not known
This also breaks in the same way (with a less useful error message) 
under 7.4.3.

Per http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20063, adding 
'dns' to the hosts lookup order in /etc/nsswitch.conf fixes the problem, 
as does using any other mask but 255.255.255.255.

Since the default config now allows TCP/IP connections from localhost, 
maybe we should tweak the default pg_hba.conf to work around this 
problem? (e.g. use the /32 syntax which works ok)

-O
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org