<div dir="ltr"><div>Hi,<br><br></div>Maybe it's bacause some Hot Standby/Streaming Replication config is missing for postgres backend nodes. Is there a recovery.conf file present in the $pgdata directory of hot_standby nodes? ¿Is the status of postgres services in hot_standby_nodes "online,recovery"? You could check <a href="https://wiki.postgresql.org/wiki/Streaming_Replication">this link</a> it both answers are no.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-06 1:52 GMT-06:00 Scott Li <span dir="ltr"><<a href="mailto:scott.li@gwghk.com" target="_blank">scott.li@gwghk.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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><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 style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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" type="button"></td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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)" type="button"> <input 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)" type="button"> <input 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)" type="button"> | <input 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)" type="button"></td></tr><tr 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 style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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" type="button"></td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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)" type="button"> <input 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)" type="button"> <input 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)" type="button"> | <input 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)" type="button"></td></tr><tr><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 style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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" type="button"></td><td style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222)" nowrap><input 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)" type="button"> <input 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)" type="button"> <input 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)" type="button"> | <input 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)" type="button"></td></tr></tbody><tfoot><tr><th colspan="8" style="padding:4px 8px;border-bottom-width:1px;border-bottom-style:solid;border-bottom-color:rgb(176,196,222);background:rgb(248,248,255)" align="right"><input 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" type="button"><br><br></th></tr></tfoot></table></div><div><br></div><div><img src="cid:ii_149840cb136cf622" alt="内嵌图片 1" height="263" width="455"></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><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><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><br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr">Job Céspedes<br></div></div>
</div>