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

Vlad Novikov xou.slackware at gmail.com
Tue Sep 13 09:51:29 JST 2016


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> wrote:

> 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?
>
>
>
>
>
> Thanks & Regards,
> ------------------------------
>
> *Subhankar Chattopadhyay*
>
> *Sr. Developer, SAP Labs | PI Tech HCP Core Platform Dev (IN)*
>
> Mobile:  +91 7829250320
>
> Office:  +91 80 4329-6071
>
> Email: <s.chattopadhyay at sap.com>  s.chattopadhyay at sap.com
>
>
>
>
>
>
>
> "A successful man is one who can lay a firm foundation with the bricks
> others have thrown at him."
>
>
>
> _______________________________________________
> 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.sraoss.jp/pipermail/pgpool-general/attachments/20160912/cb3b5a77/attachment.html>


More information about the pgpool-general mailing list