[GENERAL] Start/stop postgresql with pg_ctl or service without root access on RHEL

2017-01-20 Thread Jean-Michel Scheiwiler
Hello We plan to use postgresql on RHEL 6. DBAs won't have root access but they will need to start/stop the databases. They'll be able to do so with pg_ctl as postgres. However databases should also start automatically when the server reboots and so we should use services (/etc/init.d/postgresql

[GENERAL] Access privileges /yyyy -- role that granted this privilege.

2017-02-17 Thread Jean-Michel Scheiwiler
would get user02=c/superman but instead i get user02=c/postgres => I don't get the "role that granted this privilege" but i get the owner of the database. The problem is the same with schemas or tables access privileges. Can you help me figure this out ? Thank you in advance Jean-Michel Scheiwiler

Re: [GENERAL] Access privileges /yyyy -- role that granted this privilege.

2017-02-17 Thread Jean-Michel Scheiwiler
Ok thank you (and sorry i didn't read this line of documentation) 2017-02-17 15:18 GMT+01:00 Adrian Klaver : > On 02/17/2017 05:44 AM, Jean-Michel Scheiwiler wrote: > >> Hello, >> >> I delve into access privileges and I have a problem (or a >> miscomprehensio