Re: Commands linked to pg_wrapper not working with non-root users - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Commands linked to pg_wrapper not working with non-root users
Date
Msg-id 54116237-20a6-d7ad-1d54-5076f38c593e@aklaver.com
Whole thread Raw
In response to Re: Commands linked to pg_wrapper not working with non-root users  (Jonathan Leroy - Inikup <jonathan@inikup.com>)
List pgsql-general
On 04/11/2018 05:36 PM, Jonathan Leroy - Inikup wrote:
> 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. :)

Great. Thanks for the follow up.

> 
> Thank you all for your help!
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Jonathan Leroy - Inikup
Date:
Subject: Re: Commands linked to pg_wrapper not working with non-root users
Next
From: armand pirvu
Date:
Subject: authentication failure