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

[michail alexakis]

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

Regards, Michail








On Mon, Aug 19, 2024 at 5:38 AM Ron Johnson <ronljohnsonjr at gmail.com> wrote:

> On Sun, Aug 18, 2024 at 7:28 PM michail alexakis <drmalex07 at gmail.com>
> wrote:
>
>> 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?
>>
>> 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!
>
>
>> But, is that behavior guaranteed? (or was I just lucky in my tests?)
>>
>
> Lucky?
>
> --
> Death to America, and butter sauce.
> Iraq lobster!
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240819/b1726cc3/attachment.htm>