Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSyEv-0005NB-Th for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2015 01:36:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YSyEv-0007Wq-6E for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2015 01:36:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YSyEt-0007UK-Cn for pgsql-hackers@postgresql.org; Wed, 04 Mar 2015 01:36:43 +0000 Received: from mx-out.zmailcloud.com ([192.198.85.98] helo=mx-out-1.zmailcloud.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YSyEo-0005o1-VV for pgsql-hackers@postgresql.org; Wed, 04 Mar 2015 01:36:42 +0000 Received: from smtp.01.com (smtp.01.com [10.10.0.43]) by mx-out-1.zmailcloud.com (Postfix) with ESMTP id 41051564065 for ; Tue, 3 Mar 2015 19:36:37 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 2AC5FA043C for ; Tue, 3 Mar 2015 19:36:37 -0600 (CST) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id wiIGDHVGfaLw for ; Tue, 3 Mar 2015 19:36:37 -0600 (CST) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 03D9AA0443 for ; Tue, 3 Mar 2015 19:36:37 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id CE680A0442 for ; Tue, 3 Mar 2015 19:36:36 -0600 (CST) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id FecOVhfkpY9D for ; Tue, 3 Mar 2015 19:36:36 -0600 (CST) Received: from [10.0.1.35] (sfosj0215mups301.wiline.com [67.207.108.210]) by smtp-out-1.01.com (Postfix) with ESMTPSA id 7CF3FA043C for ; Tue, 3 Mar 2015 19:36:36 -0600 (CST) Message-ID: <54F661A2.1010000@agliodbs.com> Date: Tue, 03 Mar 2015 17:36:34 -0800 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: pgsql-hackers@postgresql.org Subject: Re: Providing catalog view to pg_hba.conf file - Patch submission References: <82897A1301080E4B8E461DDAA0FFCF14DDE1@SYD1216> <82897A1301080E4B8E461DDAA0FFCF14FD6E@SYD1216> <20140629165554.GA5984@toroid.org> <20140630070646.GY31357@toroid.org> <54F5F7DD.8020501@BlueTreble.com> <54F64F13.6010509@BlueTreble.com> In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 03/03/2015 05:07 PM, Greg Stark wrote: > On Wed, Mar 4, 2015 at 12:17 AM, Jim Nasby wrote: >> I can make these changes if you want. > > Personally I'm just not convinced this is worth it. It makes the > catalogs harder for people to read and use and only benefits people > who have users named "all" or databases named "all", "sameuser", or > "samerole" which I can't really imagine would be anyone. > > If this were going to be the infrastructure on which lots of tools > rested rather than just a read-only view that was mostly going to be > read by humans that might be different. Are you envisioning a tool > that would look at this view, offer a gui for users to make changes > based on that information, and build a new pg_hba.conf to replace it? I'm planning to write such a tool. However, I am not concerned about weird name cases like the above. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers