<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hello Everyone,</div><div dir="ltr"><br></div><div>Need assistance on below requirements. </div><div dir="ltr"><p>My requirement is to prompt for a password when connecting through Pgpool (port 9999) and to avoid using the <code>pool_password</code> file. However, I’m currently getting the error related to the lack of an entry in the <code>pool_passwd</code> file.</p><p>Could you please advise how I can achieve password authentication without using the <code>pool_password</code> file, while ensuring that Pgpool prompts for the password during connection?</p><p><br></p><p>Here is the relevant configuration from my <code>pool_hba.conf</code>:</p><pre class="gmail-!overflow-visible"><div class="gmail-contain-inline-size gmail-rounded-md gmail-border-[0.5px] gmail-border-token-border-medium gmail-relative gmail-bg-token-sidebar-surface-primary gmail-dark:bg-gray-950"><div class="gmail-flex gmail-items-center gmail-text-token-text-secondary gmail-px-4 gmail-py-2 gmail-text-xs gmail-font-sans gmail-justify-between gmail-rounded-t-md gmail-h-9 gmail-bg-token-sidebar-surface-primary gmail-dark:bg-token-main-surface-secondary gmail-select-none"><br></div><div class="gmail-overflow-y-auto gmail-p-4" dir="ltr"><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag">host</span>    <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-number">10.125</span><span class="gmail-hljs-selector-class">.0</span><span class="gmail-hljs-selector-class">.90</span>/<span class="gmail-hljs-number">32</span>       <span class="gmail-hljs-selector-tag">trust</span>            # <span class="gmail-hljs-selector-tag">Node</span> <span class="gmail-hljs-number">1</span>
<span class="gmail-hljs-selector-tag">host</span>    <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-number">10.125</span><span class="gmail-hljs-selector-class">.0</span><span class="gmail-hljs-selector-class">.91</span>/<span class="gmail-hljs-number">32</span>       <span class="gmail-hljs-selector-tag">trust</span>            # <span class="gmail-hljs-selector-tag">Node</span> <span class="gmail-hljs-number">2</span>
<span class="gmail-hljs-selector-id">#host</span>    <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-number">10.125</span><span class="gmail-hljs-selector-class">.0</span><span class="gmail-hljs-selector-class">.79</span>/<span class="gmail-hljs-number">32</span>       <span class="gmail-hljs-selector-tag">scram-sha-256</span>    # <span class="gmail-hljs-selector-tag">Node</span> <span class="gmail-hljs-number">3</span>
<span class="gmail-hljs-selector-tag">host</span>    <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-keyword">all</span>         <span class="gmail-hljs-number">0.0</span><span class="gmail-hljs-selector-class">.0</span><span class="gmail-hljs-selector-class">.0</span>/<span class="gmail-hljs-number">0</span>            <span class="gmail-hljs-selector-tag">scram-sha-256</span>    # <span class="gmail-hljs-keyword">All</span> <span class="gmail-hljs-selector-tag">nodes</span></code></div><div class="gmail-overflow-y-auto gmail-p-4" dir="ltr"><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag"><br></span></code></div><div class="gmail-overflow-y-auto gmail-p-4"><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag">error :-</span></code></div><div class="gmail-overflow-y-auto gmail-p-4"><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag">[postgres@scrbtrheldbaas002 PG_DATA]$ psql -h 10.125.0.79 -U vkp -d postgres -p 9999
psql: error: connection to server at "10.125.0.79", port 9999 failed: FATAL:  SCRAM authentication failed
DETAIL:  pool_passwd file does not contain an entry for "vkp"
</span></code></div><div><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag"><br></span></code></div><div class="gmail-overflow-y-auto gmail-p-4" dir="ltr"><code class="gmail-!whitespace-pre gmail-hljs gmail-language-less"><span class="gmail-hljs-selector-tag"><br></span></code></div></div></pre></div></div></div></div></div>