[pgpool-general: 9188] Re: reloading of pool_passwd file

Tatsuo Ishii ishii at postgresql.org
Mon Aug 19 16:10:13 JST 2024


>> My tests show that if I add a new user (which, of course, exists in the
>> Postgres backend) in pool_passwd, I can then instantly login as the new
>> user.
>>
> 
> This is my experience, too.
> 
> That tells me that pool_passwd is read every time someone connects (like
> how .pgpass is processed).  Makes for a very hot file!

No. As I said in upthread, pool_passwd is read only when pgpool reload
is executed before someone connects.

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list