Hi, I'm working on getting pgpool working in a master/slave setup using md5 authentication. Here's the versions of software I'm running:<div><br></div><div>pgpool-II-3.2.0</div><div>postgresql-9.1.5</div><div>
<br></div><div>I've setup a pool_passwd file using pg_md5 on the pgpool server for the user 'mike'. I've also setup the user 'mike' in the postgres database and updated pg_hba.conf to allow md5 connections from the pool host. As well I've setup pool_hba.conf with the following entry:</div>
<div><br></div><div>host all all <a href="http://127.0.0.1/32" target="_blank" style="color:rgb(17,85,204)">127.0.0.1/32</a> md5</div><div><br></div><div>Whenever I try to connect (via psql) I get the following error:</div>
<div><br></div><div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">psql: ERROR: MD5 authentication is unsupported in replication, master-slave and parallel modes.</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">HINT: check pg_hba.conf</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">
<br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">Any idea what might be going on there? I don't see it attempt to auth against the postgres server at all, and I'm not sure why pgpool is saying that md5 isn't allowed with master-slave mode when it sounds like it has been able to since 3.0.</div>
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">
Thanks in advance!</div><div class="yj6qo ajU" style="outline:none;padding:10px 0px;width:22px;margin:2px 0px 0px;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.800000190734863px;background-color:rgb(255,255,255)">
</div></div><div><br></div>-- <br>Michael Barrett<br>