Re: Missing or errooneous pg_hba.conf file - Mailing list pgsql-admin

From Bill Chandler
Subject Re: Missing or errooneous pg_hba.conf file
Date
Msg-id 20040524162822.35072.qmail@web12902.mail.yahoo.com
Whole thread Raw
In response to Re: Missing or errooneous pg_hba.conf file  (Bill Chandler <billybobc1210@yahoo.com>)
List pgsql-admin
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@yahoo.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@sss.pgh.pa.us> wrote:
> > 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?
> >
> >             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@postgresql.org





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

pgsql-admin by date:

Previous
From: Ericson Smith
Date:
Subject: Re: Clustering Postgres
Next
From: Greg Spiegelberg
Date:
Subject: Re: Clustering Postgres