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

[Tatsuo Ishii]

Hello Michail,

> Hello PgPool team,
> 
> How is the pool_passwd file getting reloaded when its contents have changed
> on disk (e.g. when new lines are appended)? Are contents (re)read in each
> authentication attempt, or are they reloaded when a change is detected?

After "pgpool reload" is executed (more precisely, when SIGHUP signal
is sent to each pgpool child process), it's reloaded when a client
connects to pgpool.

> 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. But, is that behavior guaranteed? (or was I just lucky in my tests?)

As far as "pgpool reload" is executed, it's guaranteed.

> I am probably missing something, but the relevant part of the documentation
> (
> https://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-POOL-PASSWD)
> does not mention how/when the file is reloaded.

You are right. The document should have mentioned about when the
content of pool_passwd is read. Probably item "pool_passwd (string) "
in "5.2.2. Authentication Settings" needs some additional
descriptions?

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