pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcfg pg_stat_statements in PG 9.5 error
6+ messages / 3 participants
[nested] [flat]
* cfg pg_stat_statements in PG 9.5 error
@ 2017-03-09 16:29 ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 6+ messages in thread
From: ghiureai @ 2017-03-09 16:29 UTC (permalink / raw)
To: 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?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: cfg pg_stat_statements in PG 9.5 error
@ 2017-03-09 17:11 Tom Lane <tgl@sss.pgh.pa.us>
parent: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2017-03-09 17:11 UTC (permalink / raw)
To: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>; +Cc: pgsql-admin
ghiureai <isabella.ghiurea@nrc-cnrc.gc.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: cfg pg_stat_statements in PG 9.5 error
@ 2017-03-09 17:49 ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: ghiureai @ 2017-03-09 17:49 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
Tom,
I am checking my cfg , I do not see a "plugins" subdirectory with
pgsql95 contrib,at least I can not find one on my host , is there other
pg conf parameter to change so can still point to initial location: ( I
read most of the plugins must cfg as extensions now)
/usr/pgsql-9.5/share/extension
Thank you
Isabella
ghiureai <isabella.ghiurea@nrc-cnrc.gc.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: cfg pg_stat_statements in PG 9.5 error
@ 2017-03-09 18:08 Tom Lane <tgl@sss.pgh.pa.us>
parent: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2017-03-09 18:08 UTC (permalink / raw)
To: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>; +Cc: pgsql-admin
ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: cfg pg_stat_statements in PG 9.5 error
@ 2017-03-09 18:12 ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: ghiureai @ 2017-03-09 18:12 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
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 <isabella.ghiurea@nrc-cnrc.gc.ca> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: cfg pg_stat_statements in PG 9.5 error
@ 2017-03-10 04:36 Stéphane KANSCHINE <stephane@hexack.fr>
parent: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 6+ messages in thread
From: Stéphane KANSCHINE @ 2017-03-10 04:36 UTC (permalink / raw)
To: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2017-03-10 04:36 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-03-09 16:29 cfg pg_stat_statements in PG 9.5 error ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
2017-03-09 17:11 ` Re: cfg pg_stat_statements in PG 9.5 error Tom Lane <tgl@sss.pgh.pa.us>
2017-03-09 17:49 ` Re: cfg pg_stat_statements in PG 9.5 error ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
2017-03-09 18:08 ` Re: cfg pg_stat_statements in PG 9.5 error Tom Lane <tgl@sss.pgh.pa.us>
2017-03-09 18:12 ` Re: cfg pg_stat_statements in PG 9.5 error ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
2017-03-10 04:36 ` Re: cfg pg_stat_statements in PG 9.5 error Stéphane KANSCHINE <stephane@hexack.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox