Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error - Mailing list pgsql-admin

From Stéphane KANSCHINE
Subject Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error
Date
Msg-id 20170310043604.hoo4uskzntlo7dmj@office.hexack.fr
Whole thread Raw
In response to Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error  (ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Cachique
Date:
Subject: Re: [ADMIN] auditing in rds or triggers that write to pg_log
Next
From: Mark Kirkwood
Date:
Subject: [ADMIN] Oracle to Postgres conversion suggestions?