<div dir="ltr"><div><div><div><div>Hi,<br><br></div>I have 2 read-only backends for select queries and I'd like to setup pgpool load balancing for them without using md5 pool_passwd file on pgpool machine.<br><br></div>When I setup pgpool with only one backend like this:<br></div><div><span style="font-family:monospace,monospace"><br></span><div style="margin-left:40px"><span style="font-family:monospace,monospace">enable_pool_hba = off</span><br><span style="font-family:monospace,monospace">pool_passwd = ''</span><br><span style="font-family:monospace,monospace">backend_hostname0 = 'pg2'</span><br></div><div style="margin-left:40px"><span style="font-family:monospace,monospace"></span></div><br></div>it works as I want to, that is first auth is passed to backend, then stored, clients can connect without problems:<br><span style="font-family:monospace,monospace"><br></span><blockquote><span style="font-family:monospace,monospace">DEBUG: pid 17273: pool_do_auth: auth kind:5</span><br><span style="font-family:monospace,monospace">DEBUG: pid 17273: trying md5 authentication</span><br><span style="font-family:monospace,monospace">DEBUG: pid 17273: DB node id: 0 salt: 58d222bc</span><br><span style="font-family:monospace,monospace">...</span><br><span style="font-family:monospace,monospace">DEBUG: pid 17273: 0 th backend: name: session_authorization value: replica_test</span><br><span style="font-family:monospace,monospace">...</span><br><span style="font-family:monospace,monospace">DEBUG: pid 17273: pool_send_auth_ok: send pid 31831 to frontend</span><br></blockquote><br></div><div>Issues start when I add second backend:<br></div><br><div style="margin-left:40px"><span style="font-family:monospace,monospace">enable_pool_hba = off</span><br><span style="font-family:monospace,monospace">pool_passwd = ''</span><br><span style="font-family:monospace,monospace">backend_hostname0 = 'pg2'</span><br><span style="font-family:monospace,monospace"></span><span style="font-family:monospace,monospace">backend_hostname1 = 'pg3'</span><br></div><div style="margin-left:40px"><span style="font-family:monospace,monospace"></span></div><div><div><div><div><div><div><div><div><span style="font-family:monospace,monospace"><br></span><br></div><div>clients get "password authentication failed" and pgpool logs:<br><br><blockquote><span style="font-family:monospace,monospace">DEBUG: pid 17328: pool_do_auth: auth kind:5<br>DEBUG: pid 17328: trying md5 authentication<br>ERROR: pid 17328: pool_get_passwd: username is NULL<br>DEBUG: pid 17328: do_md5: (null) does not exist in pool_passwd<br>DEBUG: pid 17328: do_md5failed in slot 0</span><br></blockquote><br></div><div>is it by design or bug?<br></div><div><br><br></div><div class="gmail_signature">Roman Barczyński</div><div>
</div></div></div></div></div></div></div></div></div>