[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