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

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks
Date: 2004-08-18 05:36:52
Message-ID: 4122EAF4.6090607@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Jowett 2004-08-18 05:50:39 Re: LDFLAGS vs. shared libraries
Previous Message Dennis Bjorklund 2004-08-18 04:58:31 Re: Does psql use nested transactions?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-08-18 06:05:19 Re: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks
Previous Message Zhenbang Wei 2004-08-18 04:19:12 Update 2 zh_TW message files for 8.0