X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BB514475D3B for ; Wed, 7 May 2003 16:04:16 -0400 (EDT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (Postfix) with ESMTP id 6AF91475D0F for ; Wed, 7 May 2003 16:04:15 -0400 (EDT) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 19DV9D-000Hpl-0V; Wed, 07 May 2003 21:04:16 +0100 Received: from localhost ([127.0.0.1] ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian)) id 19DV8n-0005is-00; Wed, 07 May 2003 21:03:49 +0100 Subject: Re: PostgreSQL Qs From: Oliver Elphick To: Richard Huxton Cc: Jon Earle , pgsql-general@postgresql.org In-Reply-To: <200305071832.22529.dev@archonet.com> References: <200305071832.22529.dev@archonet.com> Content-Type: text/plain Organization: LFIX Limited Message-Id: <1052337828.21371.15.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 07 May 2003 21:03:49 +0100 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-45.7 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, QUOTE_TWICE_1,REFERENCES,REPLY_WITH_QUOTES, SIGNATURE_LONG_DENSE,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/219 X-Sequence-Number: 41874 On Wed, 2003-05-07 at 18:32, Richard Huxton wrote: > On Wednesday 07 May 2003 5:35 pm, Jon Earle wrote: > > My system runs Debian, I installed postgresql from apt. It seemed to > > proceed correctly (no errors were tossed my way). As user postgres, I > > created the db and table structure. Again, seemed to proceed correctly. > > > > I changed /etc/postgresql/pg_hba.conf to: > > > > local all md5 > > host all 127.0.0.1 255.0.0.0 md5 > > host dbname 0.0.0.0 255.255.255.255 md5 > > What version is this? I've got something like (note the extra column): > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > host all all 127.0.0.1 255.255.255.255 md5 I assume he is using Debian stable, which has 7.2.1 (and will have for evermore, dammit!, until the next stable release.) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "Dearly beloved, avenge not yourselves, but rather give place unto wrath. For it is written, Vengeance is mine; I will repay, saith the Lord. Therefore if thine enemy hunger, feed him; if he thirst, give him drink; for in so doing thou shalt heap coals of fire on his head. Be not overcome of evil, but overcome evil with good." Romans 12:19-21