Skip site navigation (1) Skip section navigation (2)

Re: Missing or errooneous pg_hba.conf file

From: Bill Chandler <billybobc1210(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing or errooneous pg_hba.conf file
Date: 2004-05-24 16:28:22
Message-ID: 20040524162822.35072.qmail@web12902.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(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 

In response to

pgsql-admin by date

Next:From: Greg SpiegelbergDate: 2004-05-24 16:28:32
Subject: Re: Clustering Postgres
Previous:From: Ericson SmithDate: 2004-05-24 15:42:42
Subject: Re: Clustering Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group