[pgpool-general: 5757] Re: pgpool reload

[Tatsuo Ishii]

> Hey folks,
> I'm running with PostgreSQL 3.4 and pgpool 3.6.1, with MD5 authentication.
> 
> With the pgpool - is there a deterministic way to determine when a password change (made in pool_passwd) is picked up by pgpool after a pgpool reload?  We've noticed that the change is not immediate after the pgpool reload command returns.  Or is there a way to make the pgpool reload command synchronous, so we don't have to wait?
> 
> Of course, checking by establishing a connection with the new password is a brute force way, but we are wondering if there is something more direct.

After pgpool reload gets executed, Pgpool-II children reopen the
pgpool_passwd when a new client tries to connect to them. So pgpool
reload command is already synchronous.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp