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

Chattopadhyay, Subhankar s.chattopadhyay at sap.com
Tue Sep 13 12:33:48 JST 2016

Hi Vlad Novikov,

Thanks for your reply. As far as I know, pg_md5 is a utility to get the md5 hash of a password. Is there any such utility/sql command to insert into pool_password also? Could you please elaborate and let me know of this?

How would the script/query look like from the user’s perspective?

Thanks and Regards,

From: Vlad Novikov [mailto:xou.slackware at gmail.com]
Sent: Tuesday, September 13, 2016 6:21 AM
To: Chattopadhyay, Subhankar <s.chattopadhyay at sap.com>
Cc: pgpool-general at pgpool.net; Srivastava, Nishtha <nishtha.srivastava at sap.com>
Subject: Re: [pgpool-general: 4976] pgpool handling of User through pool password

How about just write a script that combines CREATE ROLE and pg_md5 and tell the customers to use it or call it from a web interface?

On Mon, Sep 12, 2016 at 3:17 AM, Chattopadhyay, Subhankar <s.chattopadhyay at sap.com<mailto:s.chattopadhyay at sap.com>> wrote:

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?


pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160913/ca73a534/attachment.html>

More information about the pgpool-general mailing list