From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Missing or errooneous pg_hba.conf file
Date: Wed, 19 May 2004 18:32:52 -0400
Message-ID: <m365ashwtn.fsf@wolfe.cbbrowne.com> (raw)
References: <20040519202834.15105.qmail@web12903.mail.yahoo.com>
<20717.1085001386@sss.pgh.pa.us>
After takin a swig o' Arrakan spice grog, tgl@sss.pgh.pa.us (Tom Lane) belched out:
> Bill Chandler <billybobc1210@yahoo.com> writes:
>> LOG: invalid entry in pg_hba.conf file at line 60,
>> token "255.255.255.255"
>
>> 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.
>
> Bizarre. AFAICS this must indicate that getaddrinfo() is rejecting the
> value, which perhaps could happen if some bit of it were miscoded to
> use "-1" as a failure code.
>
>> 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?
>
> Seems likely. Can you update and see if that fixes it?
Hmm... I think I have seen the same thing.
It went away when I substituted in some "grouped" entries, applying
policies to subnets rather than to individual hosts. That happened to
be a more appropriate model to use, as it cuts WAY down on the need
for pg_hba.conf entries, and on the need to modify configuration in
the future.
(We used to have, on test boxes, named IP addresses for people that
now get their IPs assigned by DHCP... Without subnet definitions,
that's a nightmare!)
We've got a box getting patched Saturday; I'll watch for that...
--
"cbbrowne","@","ntlug.org"
http://www3.sympatico.ca/cbbrowne/
Do Roman paramedics refer to IV's as "4's"?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Missing or errooneous pg_hba.conf file
In-Reply-To: <m365ashwtn.fsf@wolfe.cbbrowne.com>
References: <20040519202834.15105.qmail@web12903.mail.yahoo.com> <20717.1085001386@sss.pgh.pa.us> <m365ashwtn.fsf@wolfe.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox