<div dir="ltr">Ok, i use -D and it works fine!<div><br></div><div>Now, i have: master pgpool, slave pgpool and a <b>virtualip </b>they share.</div><div><br></div><div><b>pgpool_hba.conf</b> (on bouth servers)</div><div><br>
</div><div><i>host all all MYIP trust</i></div>
<div><div>host postgres, template1 postgres ipmaster trust</div><div>host postgres, template1 postgres ipslave trust</div></div><div><br></div><div><b>pool_password</b></div>
<div>postgres:xxxxxxxxxxxxxx</div><div><br></div><div>from host <b>MYIP</b> a do;</div><div>psql -p 5434 -h <b>virtualip </b>-U postgres</div><div><br></div><div>when i look at pg_stat_activity i see my connection from <b>masterip</b></div>
<div><br>
</div><div>and it works fine. i'm not asked for password.</div><div><br></div><div><b>I change (remove myip trust);</b></div><div><div><b>pgpool_hba.conf</b> (on bouth servers);</div><div><br></div><div><div>host postgres, template1 postgres ipmaster trust</div>
<div>host postgres, template1 postgres ipslave trust</div></div></div><div><br></div><div><br></div><div><div>from host <b>MYIP</b> a do;</div><div>psql -p 5434 -h virtualip -U postgres</div>
</div><div><br></div>
<div>and i'm not allowed to login</div><div><br></div><div>finally i change (md5 for myip):</div><div><b>pgpool_hba.conf</b> (on bouth servers)<br></div><div><div><br></div><div><i>host all all MYIP </i><b>md5</b></div>
<div><div>host postgres, template1 postgres ipmaster trust</div><div>host postgres, template1 postgres ipslave trust</div></div></div><div><br></div><div>
<br></div><div><br></div><div><div>from host <b>MYIP</b> a do;</div><div>psql -p 5434 -h virtualip -U postgres</div></div><div><br></div><div>and i can log in without been asked for password</div><div><br></div><div>if i use:</div>
<div><br></div><div>psql -p 5434 -h virtualip -U postgres -W<br>
</div><div><br></div><div>and i don't write any password, i still can connect!(?)</div><div><br></div><div>what i'm doing wrong!?</div><div><br></div><div><br></div><div>Tks!<br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Tue, Mar 11, 2014 at 11:58 PM, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On Tue, 11 Mar 2014 12:02:26 -0300<br>
Gonzalo Gil <<a href="mailto:gonxalo2000@gmail.com">gonxalo2000@gmail.com</a>> wrote:<br>
<br>
> it's done now.<br>
><br>
> My problem now is that i am in a prod ambient... so i can play very much...<br>
><br>
> i have:<br>
> node1, primary pgpool (with virtual ip) and primary database<br>
> node2, standby node (database and pgpool)<br>
><br>
> i add a node (2nd standby in standby server) /datastb in pgpool.conf (bouth<br>
> nodes)<br>
><br>
> from node1:<br>
> # pcp_node_info 10 localhost 9898 postgres postgres 0<br>
</div>> prod 5432 *3* 1.000000<br>
<div class="">> # pcp_node_info 10 localhost 9898 postgres postgres 1<br>
</div>> replica 5432 *1* 0.000000<br>
<div class="">> # pcp_node_info 10 localhost 9898 postgres postgres 2<br>
> replica 5444 3 0.000000<br>
><br>
> why node 0 (local) is donw!?<br>
<br>
</div>pgpool reads a file containing backend status at startup. pgpool at node #0<br>
might read an old status file. To avoid this, start pgpool with -D option<br>
and pgpool will discards the old status file.<br>
<br>