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

Christophe Pettus xof at thebuild.com
Thu Jan 15 08:26:47 JST 2015


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