Re: cfg pg_stat_statements in PG 9.5 error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux