Re: Commands linked to pg_wrapper not working with non-root users

Поиск
Список
Период
Сортировка
От Jonathan Leroy - Inikup
Тема Re: Commands linked to pg_wrapper not working with non-root users
Дата
Msg-id CAC88fzEpaHFdQK0qcZr=WnWY73F6jxT3JwTxOK7nrM6Ci+vmPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Commands linked to pg_wrapper not working with non-root users  (Jonathan Leroy - Inikup <jonathan@inikup.com>)
Ответы Re: Commands linked to pg_wrapper not working with non-root users  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
2018-04-12 1:49 GMT+02:00 Jonathan Leroy - Inikup <jonathan@inikup.com>:
> Maybe I will try to "dissect" pg_wrapper to find where the error
> occurs, but the script is quite complex...

OK, I've found the issue : pg_wrapper is trying to get the value of
the "data_directory" setting by reading the postgresql.conf file.
However, my user can't access the postgresql.conf file.

So I've bootstrapped a fresh Debian 8 VM with just postgresql-9.6, and
compared files permissions between that VM and my production servers.
All my production postgresql.conf files have a chmod 640 vs 644 on my new VM.

After digging, I've found that the SaltStack recipe who configure all
my servers force the file chmod to 640...
I've fixed it: everything works now. :)

Thank you all for your help!

-- 
Jonathan Leroy


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Commands linked to pg_wrapper not working with non-root users
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Commands linked to pg_wrapper not working with non-root users