Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cmCHf-0006Wd-6g for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 04:36:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cmCHe-00071n-GC for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 04:36:06 +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 1cmCHd-00070x-Lm for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 04:36:05 +0000 Received: from r0.smtpout1.alwaysdata.com ([2001:41d0:8:4734:1:0:10:1]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cmCHa-00042r-55 for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 04:36:04 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=alwaysdata.net; s=carxwol; h=In-Reply-To:Content-Transfer-Encoding: Content-Type:MIME-Version:References:Message-ID:Subject:Cc:To:From:Date: Sender:Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=/fxe5qkL4MjFTA0sAlEGX1H/dUdNWDntlEiY39G0aKk=; b=GhdJNbHoOpMzKYJ94E5Y8C+Adv CC9sC47YdGmsKjsDvDN8FBMH8Ewrg2k6LQMLwSHXP9RQ9RIL3N0xKyeIbavWp2oW8xgYaCPx8yuYC 2Ghhbx4zR+V2dzo3c+rcOJxxRW06EAZoFy7CLlqgpg4wM6L2IcqN+1fPhTh4xJnEeRio=; Received: from [78.193.183.71] (helo=office.hexack.fr) by smtpout1.roubaix1.alwaysdata.com with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.88) (envelope-from ) id 1cmCHV-0004fe-6M; Fri, 10 Mar 2017 05:35:57 +0100 Date: Fri, 10 Mar 2017 05:36:04 +0100 From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE To: ghiureai Cc: pgsql-admin@postgresql.org Subject: Re: cfg pg_stat_statements in PG 9.5 error Message-ID: <20170310043604.hoo4uskzntlo7dmj@office.hexack.fr> 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> <58C19B18.1010003@nrc-cnrc.gc.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <58C19B18.1010003@nrc-cnrc.gc.ca> Organization: HexACK User-Agent: NeoMutt/20161126 (1.7.1) X-alwaysdata-ID: 212927067 X-Pg-Spam-Score: -1.1 (-) 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 Hi, Le jeu. 9 mars, vers 10:12, ghiureai exprimait : > > 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? For files, Debian and PGDG gives the ownership to root. For objects, it depends on which user launches the create extension (end of Description) : https://www.postgresql.org/docs/9.5/static/sql-createextension.html Regards, -- Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./ ＠ stephane@hexack.fr  +33 6 64 31 72 52 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin