| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: cfg pg_stat_statements in PG 9.5 error |
| Date: | 2017-03-09 17:11:56 |
| Message-ID: | 23959.1489079516@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca> writes:
> 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?
Libraries to be loaded via local_preload_libraries must be in the plugins
subdirectory. See the manual's description of that parameter.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Broers | 2017-03-09 17:37:17 | auditing in rds or triggers that write to pg_log |
| Previous Message | ghiureai | 2017-03-09 16:29:35 | cfg pg_stat_statements in PG 9.5 error |