Re: cfg pg_stat_statements in PG 9.5 error

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: cfg pg_stat_statements in PG 9.5 error
Date: 2017-03-10 04:36:04
Message-ID: 20170310043604.hoo4uskzntlo7dmj@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Kirkwood 2017-03-10 08:42:57 Oracle to Postgres conversion suggestions?
Previous Message Cachique 2017-03-09 18:16:44 Re: auditing in rds or triggers that write to pg_log