<div dir="ltr"><div class="gmail_quote"><div dir="ltr">Hi, <div><br></div><div> I installed [pgpool-II Master Slave mode / Load Balance Mode / Watchdog On</div><div>but three postgresql servers are all primary server, shows as below:</div><div><br></div><div><table style="border-top-width:1px;border-top-style:solid;border-top-color:rgb(176,196,222);border-collapse:collapse;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:x-small"><thead><tr><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"></th><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"><label>IP Address</label></th><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"><label>Port</label></th><th colspan="2" style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"><label>Status</label></th><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"><label>Weight</label></th><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"></th><th style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"></th></tr></thead><tbody><tr class=""><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">node 0</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">192.168.35.150</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">5432</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">Up. Connected. Running as primary server</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">postgres: Up</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">0.333</td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" name="command" value="Disconnect" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;background-image:-webkit-gradient(linear,0% 0%,0% 100%,from(rgb(255,255,255)),to(rgb(238,238,238)));background-repeat:initial"></td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" disabled value="Stop" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Restart" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Reload" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> | <input type="button" disabled value="Remove" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"></td></tr><tr class="" style="background:rgb(240,255,255)"><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">node 1</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">192.168.35.151</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">5432</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">Up. Connected. Running as primary server</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">postgres: Up</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">0.333</td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" name="command" value="Disconnect" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;background-image:-webkit-gradient(linear,0% 0%,0% 100%,from(rgb(255,255,255)),to(rgb(238,238,238)));background-repeat:initial"></td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" disabled value="Stop" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Restart" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Reload" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> | <input type="button" disabled value="Remove" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"></td></tr><tr class=""><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">node 2</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">192.168.35.152</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">5432</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">Up. Connected. Running as primary server</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">postgres: Up</td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)">0.333</td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" name="command" value="Disconnect" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;background-image:-webkit-gradient(linear,0% 0%,0% 100%,from(rgb(255,255,255)),to(rgb(238,238,238)));background-repeat:initial"></td><td nowrap style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)"><input type="button" disabled value="Stop" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Restart" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> <input type="button" disabled value="Reload" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"> | <input type="button" disabled value="Remove" style="font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(119,119,119);background:rgb(222,222,222)"></td></tr></tbody><tfoot><tr><th colspan="8" align="right" style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)"><input type="button" id="button_add_backend" value="Add a new backend node" style="font-weight:normal;font-size:x-small;font-family:Verdana,Arial,Helvetica,sans-serif;padding:2px 5px;vertical-align:middle;border-width:1px;border-style:solid;border-color:rgb(170,170,170) rgb(102,102,102) rgb(102,102,102) rgb(170,170,170);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;background-image:-webkit-gradient(linear,0% 0%,0% 100%,from(rgb(255,255,255)),to(rgb(238,238,238)));background-repeat:initial"><br><br></th></tr></tfoot></table></div><div><br></div><div><img src="cid:ii_149840cb136cf622" alt="内嵌图片 1" width="455" height="263"></div><div><br></div><div><a href="http://www.pgpool.net/download.php?f=installer2-pg93-3.3.4.tar.gz" rel="nofollow" style="text-decoration:none;color:rgb(51,102,187);padding-right:13px;font-family:sans-serif;font-size:13px;line-height:19.2000007629395px" target="_blank">installer2-pg93-3.3.4.tar.gz</a> <br></div><div>version: pgpool3.3.4</div><div><br></div><div>pgpool config:<br></div><div><div>listen_addresses = '*'</div><div>archive_mode = on</div><div>wal_level = hot_standby</div><div>max_wal_senders = 2</div><div>hot_standby = on</div><div>logging_collector = on</div><div>log_filename = '%A.log'</div><div>log_line_prefix = '%t [%p-%l] '</div><div>log_truncate_on_rotation = on</div><div>pgpool.pg_ctl = '/usr/pgsql-9.3/bin/pg_ctl'</div><div>archive_command = 'cp %p /var/lib/pgsql/arc/%f </dev/null'</div><div>port = 5432</div></div><div><br></div><div>postgres config:</div><div><div>listen '*'</div><div>port 5432</div><div>wal_level = hot_standby<span style="white-space:pre-wrap"> </span></div><div>hot_standby = on</div></div><div><br></div><div>and the install is directed by install.sh under installer2-pg93-3.3.4, anybody can help? </div><div><br></div><div><br clear="all"><div><br></div><div><div dir="ltr"><div>Thanks & Regards</div><span class=""><font color="#888888"><div><br></div><div>Scott Li</div></font></span></div></div></div></div></div>
</div>
<br>
<p style="text-align:left"></p><p style="text-align:left"><font size="2"><font color="#808080" face="'Times New Roman', serif">Confidentiality Warning: </font><span style="color:rgb(128,128,128);font-family:'Times New Roman',serif">This e-mail contains information intended only for the use of the individual or entity named above. </span><span style="color:rgb(128,128,128);font-family:'Times New Roman',serif">If the reader of this e-mail is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, any dissemination, publication or copying of this e-mail is strictly prohibited. </span><span style="color:rgb(128,128,128);font-family:'Times New Roman',serif">The sender does not accept any responsibility for any loss, disruption or damage to your data or computer system that may occur while using data contained in, or transmitted with, this e-mail. </span><span style="color:rgb(128,128,128);font-family:'Times New Roman',serif">If you have received this e-mail in error, please immediately notify us by return e-mail. Thank you.</span></font></p><p></p>