Re: Missing or errooneous pg_hba.conf file

Hi all,

I had my Solaris 8 machine upgraded with latest
patches. No change. Still does not like
255.255.255.255. Using the alternate format of
IP-address/32 does fix the problem, though so glad to
have a workaround. Still it would be nice to know why
this happens on some systems and not on others.

Does anybody know of any system config parameters
that would affect this? Enironment variables? Config
files in /etc?

Very strange.

Thanks,

Bill
--- Bill Chandler <billybobc1210(at)yahoo(dot)com> wrote:
> I am in the process of having the Solaris 8 machine
> upgrading w/ latest patches. I will let you know
> if it fixes the problem.
>
> Thanks.
>
> Bill
>
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Bill Chandler <billybobc1210(at)yahoo(dot)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?
> >
> > regards, tom lane
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Domains Claim yours for only $14.70/year
> http://smallbusiness.promotions.yahoo.com/offer
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org

__________________________________
Do you Yahoo!?
Yahoo! Domains Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer