<div dir="ltr">How about just write a script that combines CREATE ROLE and pg_md5?</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 12, 2016 at 3:17 AM, Chattopadhyay, Subhankar <span dir="ltr"><<a href="mailto:s.chattopadhyay@sap.com" target="_blank">s.chattopadhyay@sap.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We provide PostgreSQL as a service on cloud and manage the database cluster. We have pgpool to handle the client queries.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Currently, as I understand, pgpool has md5 mechanism of authentication where the PostgreSQL users will have to be added in the pool-password file.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Is there a way pgpool can automatically add these users to pool-password? Is there a hook available for this?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1f497d">Thanks & Regards,
<u></u><u></u></span></p>
<div>
<div>
<div>
<div class="MsoNormal" style="text-autospace:none">
<hr size="1" width="33%" align="left">
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;font-family:"Times New Roman",serif;color:#1f497d">Subhankar Chattopadhyay</span></b><span style="font-size:10.0pt"><u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;color:#548dd4">Sr. Developer, SAP Labs | PI Tech HCP Core Platform Dev (IN)<u></u><u></u></span></b></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;color:#5f497a">Mobile: <a href="tel:%2B91%207829250320" value="+917829250320" target="_blank">+91 7829250320</a> </span><b><span style="font-size:10.0pt;color:#548dd4"><u></u><u></u></span></b></p>
<p class="MsoNormal" style="margin-left:.25in;text-autospace:none">
<span style="font-size:10.0pt;color:#5f497a">Office: <a href="tel:%2B91%2080%204329-6071" value="+918043296071" target="_blank">+91 80 4329-6071</a><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.25in;text-autospace:none">
<span lang="DE"><a href="mailto:s.chattopadhyay@sap.com" target="_blank"><span lang="EN-US" style="font-size:10.0pt;color:#5f497a">Email:</span></a></span><span style="font-size:10.0pt;color:#5f497a">
</span><span lang="DE"><a href="mailto:s.chattopadhyay@sap.com" target="_blank"><span lang="EN-US" style="font-size:10.0pt;color:#5f497a">s.chattopadhyay@sap.com</span></a></span><span style="font-size:10.0pt;color:#5f497a"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.25in;text-autospace:none">
<span style="font-size:10.0pt;color:#5f497a"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-left:.25in;text-autospace:none">
<span style="font-size:10.0pt;color:#5f497a"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-left:.25in;text-autospace:none">
<span style="font-size:10.0pt;color:#5f497a"><u></u> <u></u></span></p>
<p class="MsoNormal" align="center" style="margin-left:.25in;text-align:center;text-autospace:none">
<span lang="DE"><a><span lang="EN-US" style="font-size:8.0pt;font-family:"Lucida Calligraphy";color:gray">"A successful man is one who can lay a firm foundation with the bricks others have thrown at him."</span></a></span><span style="font-size:10.0pt;color:#5f497a"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>