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

[Ron Johnson]

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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240818/78a3f3d5/attachment.htm>