cfg pg_stat_statements in PG 9.5 error

From: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: cfg pg_stat_statements in PG 9.5 error
Date: 2017-03-09 16:29:35
Message-ID: 58C182EF.3030405@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List ,
I am seeing the following issue:
I have to cfg pg_stat_statements in Pg version 9.5.1: I create the
extension inside db , next cfg:

local_preload_libraries =
'/usr/pgsql-9.5/share/extension/pg_stat_statements'

when re-starting the PG server seeing this in errorlog :
FATAL: access to library
"/usr/pgsql-9.5/share/extension/pg_stat_statements" is not allowed

I have root with full permission to the "/usr/pgsql-9.5/ and user
postgres with exec only , what I am missing form this cfg?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-03-09 17:11:56 Re: cfg pg_stat_statements in PG 9.5 error
Previous Message Aldo Sarmiento 2017-03-08 22:53:42 Re: pg_backrest no longer backing up