X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 807868B9B49 for ; Tue, 22 Feb 2005 13:26:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58571-04 for ; Tue, 22 Feb 2005 13:26:14 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 81A8B8B9B19 for ; Tue, 22 Feb 2005 13:26:16 +0000 (GMT) Received: from [10.4.0.5] (helo=eris.tenfour) by 9.hellooperator.net with esmtp (Exim 4.43) id 1D3a3M-0000aM-A6 for pgsql-admin@postgresql.org; Tue, 22 Feb 2005 13:26:16 +0000 Received: from rasputnik by eris.tenfour with local (Exim 4.44 (FreeBSD)) id 1D3a3M-0009b9-1v for pgsql-admin@postgresql.org; Tue, 22 Feb 2005 13:26:16 +0000 Date: Tue, 22 Feb 2005 13:26:15 +0000 From: Dick Davies To: PostgreSQL Admin Subject: Re: pg_hba.conf Message-ID: <20050222132615.GS66519@eris.tenfour> Reply-To: Dick Davies References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.499 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200502/213 X-Sequence-Number: 16381 * K?PFERL Robert [0228 12:28]: > According to the excelent doc, the _first_ matching entry will be used. If that were true, the below would work, surely? > C:\> I have this: > C:\> > C:\> root@eris:postgresql80-server$ cat /opt/pgsql/data/pg_hba.conf > C:\> # TYPE DATABASE USER IP-ADDRESS METHOD > C:\> local all all trust > C:\> host all all 10.2.3.4/32 md5 > C:\> hostssl all all 0.0.0.0/0 md5 -- 'Interesting. No, wait, the other thing - Tedious.' -- Bender Rasputin :: Jack of All Trades - Master of Nuns