[pgpool-general: 9190] Re: reloading of pool_passwd file
Tatsuo Ishii
ishii at postgresql.org
Mon Aug 19 18:14:43 JST 2024
> Hello Tatsuo and thanks for your quick response!
>
> My impression is that (as Ron also mentioned) the contents of pool_passwd
> are read on every connection (authentication) attempt. I mean, at least for
> a handful of tests I performed, the new users were seen without a need for
> a reload (but this could also be luck[1]). So, is a reload really necessary
> here?
>
> [1] e.g some Pgpool child processes see the updated version of pool_passwd,
> while others see the old (cached?) one
I confirmed using gdb that without pgpool reload, pool_passwd is never
re-read at least on master branch. Are you sure that you are the only
user of pgpool at that point? I suspect someone else executed pgpool
reload.
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