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
