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 2BC7DD1B274 for ; Wed, 19 May 2004 20:19:46 -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 56255-03 for ; Wed, 19 May 2004 20:19:28 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 96BB6D1B350 for ; Wed, 19 May 2004 20:19:25 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4JNJNT3034374 for ; Wed, 19 May 2004 23:19:25 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4JMoTWx025477 for pgsql-admin@postgresql.org; Wed, 19 May 2004 22:50:29 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Missing or errooneous pg_hba.conf file Date: Wed, 19 May 2004 18:32:52 -0400 Organization: cbbrowne Computing Inc Lines: 35 Message-ID: References: <20040519202834.15105.qmail@web12903.mail.yahoo.com> <20717.1085001386@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:dBvdAWg21reMZedFY2h6KFBLyXU= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200405/202 X-Sequence-Number: 13518 After takin a swig o' Arrakan spice grog, tgl@sss.pgh.pa.us (Tom Lane) belched out: > 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? Hmm... I think I have seen the same thing. It went away when I substituted in some "grouped" entries, applying policies to subnets rather than to individual hosts. That happened to be a more appropriate model to use, as it cuts WAY down on the need for pg_hba.conf entries, and on the need to modify configuration in the future. (We used to have, on test boxes, named IP addresses for people that now get their IPs assigned by DHCP... Without subnet definitions, that's a nightmare!) We've got a box getting patched Saturday; I'll watch for that... -- "cbbrowne","@","ntlug.org" http://www3.sympatico.ca/cbbrowne/ Do Roman paramedics refer to IV's as "4's"?