From: Bill Chandler <billybobc1210@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Missing or errooneous pg_hba.conf file
Date: Mon, 24 May 2004 09:28:22 -0700 (PDT)
Message-ID: <20040524162822.35072.qmail@web12902.mail.yahoo.com> (raw)
In-Reply-To: <20040520214134.89785.qmail@web12907.mail.yahoo.com>
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
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: billybobc1210@yahoo.com
Subject: Re: Missing or errooneous pg_hba.conf file
In-Reply-To: <20040524162822.35072.qmail@web12902.mail.yahoo.com>
References: <20040520214134.89785.qmail@web12907.mail.yahoo.com> <20040524162822.35072.qmail@web12902.mail.yahoo.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