Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] cfg pg_stat_statements in PG 9.5 error - Mailing list pgsql-admin

From ghiureai
Subject [ADMIN] cfg pg_stat_statements in PG 9.5 error
Date
Msg-id 58C182EF.3030405@nrc-cnrc.gc.ca
Whole thread Raw
Responses Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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?

pgsql-admin by date:

Previous
From: Aldo Sarmiento
Date:
Subject: Re: [ADMIN] pg_backrest no longer backing up
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error