[pgpool-general: 4978] Re: pgpool handling of User through pool password

[Tatsuo Ishii]

> Hi,
> 
> We provide PostgreSQL as a service on cloud and manage the database cluster. We have pgpool to handle the client queries.
> 
> Currently, as I understand, pgpool has md5 mechanism of authentication where the PostgreSQL users will have to be added in the pool-password file.
> 
> Now if an application user creates any additional users from these users, these additional users are not able to connect to PostgreSQL through pgpool as the user password are not registered in the pool password file.
> 
> Is there a way pgpool can automatically add these users to pool-password? Is there a hook available for this?

Unfortunately there's no such a hook is implemented. Probably by
intercepting "ALTER USER" query in Pgpool-II, you could automatically
update pool_passwd but it requires non trivial modification to
Pgpool-II source code.

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