Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YGagY-000364-Hp for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2015 22:02:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YGagY-0003FE-1c for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2015 22:02:06 +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 1YGagV-0003CZ-Uq for pgsql-hackers@postgresql.org; Wed, 28 Jan 2015 22:02:04 +0000 Received: from mail-bn1bon0696.outbound.protection.outlook.com ([2a01:111:f400:fc10::1:696] helo=na01-bn1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YGagR-0003vS-EW for pgsql-hackers@postgresql.org; Wed, 28 Jan 2015 22:02:02 +0000 Received: from decina.local (107.192.31.176) by DM2PR11MB0349.namprd11.prod.outlook.com (25.160.136.155) with Microsoft SMTP Server (TLS) id 15.1.65.19; Wed, 28 Jan 2015 22:01:53 +0000 Message-ID: <54C95C4B.2080901@BlueTreble.com> Date: Wed, 28 Jan 2015 16:01:47 -0600 From: Jim Nasby User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: Haribabu Kommi CC: Abhijit Menon-Sen , "pgsql-hackers@postgresql.org" , "Prabakaran, Vaishnavi" , Magnus Hagander , Jaime Casanova 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> <54C8156E.1080500@BlueTreble.com> In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [107.192.31.176] X-ClientProxiedBy: BY1PR00CA0020.namprd00.prod.outlook.com (25.160.102.30) To DM2PR11MB0349.namprd11.prod.outlook.com (25.160.136.155) Authentication-Results: 2ndquadrant.com; dkim=none (message not signed) header.d=none;2ndquadrant.com; dmarc=none action=none header.from=BlueTreble.com; X-DmarcAction-Test: None X-Microsoft-Antispam: UriScan:; X-Microsoft-Antispam: BCL:0;PCL:0;RULEID:(3005004);SRVR:DM2PR11MB0349; X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004); SRVR:DM2PR11MB0349; X-Forefront-PRVS: 047001DADA X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(377454003)(479174004)(24454002)(51704005)(36756003)(40100003)(122386002)(33656002)(2950100001)(93886004)(92566002)(86362001)(62966003)(42186005)(77156002)(66066001)(65806001)(80316001)(19580395003)(65816999)(47776003)(50466002)(15975445007)(64126003)(83506001)(54356999)(110136001)(46102003)(87976001)(65956001)(87266999)(59896002)(50986999)(23676002)(76176999)(85282002); DIR:OUT; SFP:1101; SCL:1; SRVR:DM2PR11MB0349; H:decina.local; FPR:; SPF:None; MLV:sfv; LANG:en; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:;SRVR:DM2PR11MB0349; X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 28 Jan 2015 22:01:53.5015 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR11MB0349 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 1/28/15 12:46 AM, Haribabu Kommi wrote: >> >Also, what happens if someone reloads the config in the middle of running >> >the SRF? > hba entries are reloaded only in postmaster process, not in every backend. > So there shouldn't be any problem with config file reload. Am i > missing something? Ahh, good point. That does raise another issue though... there might well be some confusion about that. I think people are used to the varieties of how settings come into effect that perhaps this isn't an issue with pg_settings, but it's probably worth at least mentioning in the docs for a pg_hba view. -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers