[pgpool-general: 3425] Re: couldn't open /etc/pgpool2/pool_passwd. reason: Permission denied

Tatsuo Ishii ishii at postgresql.org
Thu Jan 15 21:41:28 JST 2015


Good question. Looking at the code, I think pgpool-II itself does not
write to the file. Probably we should change pgpool-II to not require
write access to the file.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Thank you, that worked great.
> 
> Just out of curiosity, *why* does pgpool2 need to write to pool_passwd?
> 
> On Jan 13, 2015, at 11:02 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> pool_passwd needs to be writable by pgpool process.
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> 
>>> In a new pgpool2 installation (3.3.4), I'm getting the following errors in the log:
>>> 
>>> Jan 14 06:21:48 ip-10-181-32-109 pgpool[22069]: pool_init_pool_passwd: couldn't open /etc/pgpool2/pool_passwd. reason: Permission denied
>>> 
>>> What's odd is that the file exists, and is readable:
>>> 
>>> $ ls -la /etc/pgpool2/pool_passwd
>>> -rw-r--r-- 1 root root 44 Jan 14 05:52 /etc/pgpool2/pool_passwd
>>> 
>>> The file was created using pg_md5
>>> --
>>> -- Christophe Pettus
>>>   xof at thebuild.com
>>> 
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 
> --
> -- Christophe Pettus
>    xof at thebuild.com
> 


More information about the pgpool-general mailing list