X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD81D1B23F for ; Mon, 24 May 2004 13:28:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07611-01 for ; Mon, 24 May 2004 13:28:24 -0300 (ADT) Received: from web12902.mail.yahoo.com (web12902.mail.yahoo.com [216.136.174.69]) by svr1.postgresql.org (Postfix) with SMTP id 840C3D1B276 for ; Mon, 24 May 2004 13:28:22 -0300 (ADT) Message-ID: <20040524162822.35072.qmail@web12902.mail.yahoo.com> Received: from [192.88.67.254] by web12902.mail.yahoo.com via HTTP; Mon, 24 May 2004 09:28:22 PDT Date: Mon, 24 May 2004 09:28:22 -0700 (PDT) From: Bill Chandler Subject: Re: Missing or errooneous pg_hba.conf file To: pgsql-admin@postgresql.org In-Reply-To: <20040520214134.89785.qmail@web12907.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200405/247 X-Sequence-Number: 13563 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 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 wrote: > > Bill Chandler 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