Re: cfg pg_stat_statements in PG 9.5 error

From: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: cfg pg_stat_statements in PG 9.5 error
Date: 2017-03-09 18:12:40
Message-ID: 58C19B18.1010003@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Cachique 2017-03-09 18:16:44 Re: auditing in rds or triggers that write to pg_log
Previous Message Tom Lane 2017-03-09 18:08:41 Re: cfg pg_stat_statements in PG 9.5 error