Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cm2bA-00025o-KS for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2017 18:15:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cm2bA-0003RB-2V for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2017 18:15:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cm2b9-0003Mx-6k for pgsql-admin@postgresql.org; Thu, 09 Mar 2017 18:15:35 +0000 Received: from nrccenhts1.nrc.ca ([132.246.15.88]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cm2b7-0008Kt-Ao for pgsql-admin@postgresql.org; Thu, 09 Mar 2017 18:15:34 +0000 Received: from [132.246.194.15] (132.246.11.2) by nrccenhts1.nrc.ca (132.246.15.88) with Microsoft SMTP Server (TLS) id 8.3.348.2; Thu, 9 Mar 2017 13:15:31 -0500 Message-ID: <58C19B18.1010003@nrc-cnrc.gc.ca> Date: Thu, 9 Mar 2017 10:12:40 -0800 From: ghiureai User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130110 Thunderbird/17.0.2 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" CC: Tom Lane Subject: Re: cfg pg_stat_statements in PG 9.5 error References: <58C182EF.3030405@nrc-cnrc.gc.ca> <23959.1489079516@sss.pgh.pa.us> <58C19590.1010905@nrc-cnrc.gc.ca> <26257.1489082921@sss.pgh.pa.us> In-Reply-To: <26257.1489082921@sss.pgh.pa.us> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org I solved my issue by cfg : shared_preload_libraries param. Tom, please what is the general recommendation for Pg contrib module ownership : user postgres or root? Thanks Isabella On 03/09/2017 10:08 AM, Tom Lane wrote: > ghiureai writes: >> I am checking my cfg , I do not see a "plugins" subdirectory with >> pgsql95 contrib, > There isn't one in a default configuration. It's on the head of the > local DBA to decide which libraries he/she is willing to allow in > local_preload_libraries, and copy or move them into a plugins > subdirectory. > > regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin