X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A78E89DC822 for ; Wed, 1 Mar 2006 18:14:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18261-09 for ; Wed, 1 Mar 2006 18:14:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.vianet.ca (smtp.vianet.ca [209.91.128.40]) by postgresql.org (Postfix) with SMTP id 2BA769DC809 for ; Wed, 1 Mar 2006 18:14:44 -0400 (AST) Received: (qmail 21510 invoked from network); 1 Mar 2006 22:14:46 -0000 Received: from unknown (HELO ?192.168.99.15?) (209.91.179.117) by smtp.vianet.ca with SMTP; 1 Mar 2006 22:14:46 -0000 Message-ID: <44061CC3.1070300@vianet.ca> Date: Wed, 01 Mar 2006 17:14:27 -0500 From: Kris Deugau Organization: ViaNet User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Need reference doc on precedence/ordering for pg_hba.conf Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/14 X-Sequence-Number: 20771 In particular, something quite a bit more verbose than the offical docs on www.postgresql.org/docs (which are good, but not quite detailed enough for me to unravel which entry in one particular pg_hba.conf is taking precedence, and how to add several new entries that won't break anything else). Every experiment I've tried has *almost* worked in the manner I'm understanding from every bit of documentation I've found, but something always breaks. :( Failing that, a diagnostic poke to the head to tell me where in this config I should put entries that refer to both local socket connections and remote TCP/IP connections for one specific database that I want MD5 (or crypt, for the old 6.x client :/ ) authentication on: ========= # From Debian Sarge stock install local all postgres ident sameuser local all all ident sameuser # Added for local software using PG local template1 all ident local sameuser all md5 local all root trust # More entries from stock Debian package host all all 127.0.0.1 255.255.255.255 ident sameuser host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser host all all ::ffff:127.0.0.1/128 ident sameuser # another local config - the real entry contains a real IP host all all [host IP] 255.255.255.255 trust # Last stock entry host all all 0.0.0.0 0.0.0.0 reject ========= (Comments trimmed out, whitespace mostly compacted; linewraps are not present in the real file - but my new entries don't function as expected when I put them where I *think* they should go.) -kgd