<html><head><meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div>Hello,<span></span></div><div> Are you sure all the standby nodes are alive?</div><div> if they are ,maybe you can stop the pgpool firstly, and then use the command 'pgpool -C -D ' to start the pgpool,</div><div> '-D ' means that re-created the pgpool status file.</div><div> Hope it works</div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">mandy</div></span></div>
<blockquote style="margin-Top: 0px; margin-Bottom: 0px; margin-Left: 0.5em"><div> </div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><div><b>From:</b> <a href="mailto:pgpool-general-request@pgpool.net">pgpool-general-request</a></div><div><b>Date:</b> 2018-11-22 11:00</div><div><b>To:</b> <a href="mailto:pgpool-general@pgpool.net">pgpool-general</a></div><div><b>Subject:</b> pgpool-general Digest, Vol 85, Issue 17</div></div></div><div><div> </div>
<div>Send pgpool-general mailing list submissions to</div>
<div> pgpool-general@pgpool.net</div>
<div> </div>
<div>To subscribe or unsubscribe via the World Wide Web, visit</div>
<div> http://www.sraoss.jp/mailman/listinfo/pgpool-general</div>
<div>or, via email, send a message with subject or body 'help' to</div>
<div> pgpool-general-request@pgpool.net</div>
<div> </div>
<div>You can reach the person managing the list at</div>
<div> pgpool-general-owner@pgpool.net</div>
<div> </div>
<div>When replying, please edit your Subject line so it is more specific</div>
<div>than "Re: Contents of pgpool-general digest..."</div>
<div> </div>
<div> </div>
<div>Today's Topics:</div>
<div> </div>
<div> 1. [pgpool-general: 6304] Re: PGPool does not balance between</div>
<div> slaves (Tatsuo Ishii)</div>
<div> </div>
<div> </div>
<div>----------------------------------------------------------------------</div>
<div> </div>
<div>Message: 1</div>
<div>Date: Thu, 22 Nov 2018 10:31:24 +0900 (JST)</div>
<div>From: Tatsuo Ishii <ishii@sraoss.co.jp></div>
<div>To: franklinbr@gmail.com</div>
<div>Cc: pgpool-general@pgpool.net</div>
<div>Subject: [pgpool-general: 6304] Re: PGPool does not balance between</div>
<div> slaves</div>
<div>Message-ID: <20181122.103124.1332066456578854588.t-ishii@sraoss.co.jp></div>
<div>Content-Type: Text/Plain; charset=us-ascii</div>
<div> </div>
<div>Probably status of PostgreSQL servers are out of sync with what</div>
<div>Pgpool-II recognizes. Stop Pgpool-II and remove "pgpool_status" file,</div>
<div>which should be located under "logdir" directory specified in</div>
<div>pgpool.conf. Then start Pgpool-II again. The pgpool_status file is</div>
<div>automatically re-created upon starting up.</div>
<div> </div>
<div>Best regards,</div>
<div>--</div>
<div>Tatsuo Ishii</div>
<div>SRA OSS, Inc. Japan</div>
<div>English: http://www.sraoss.co.jp/index_en.php</div>
<div>Japanese:http://www.sraoss.co.jp</div>
<div> </div>
<div>> Hello Guys.</div>
<div>> </div>
<div>> I have a pgpool with five postgresql servers, one master and three slaves</div>
<div>> in mode sync.</div>
<div>> I chose streaming replication mode of pgpool based on file</div>
<div>> $prefix/etc/pgpool.conf.sample-stream.</div>
<div>> But when i execute on psql show pool_nodes i have this result</div>
<div>> </div>
<div>> </div>
<div>> postgres=# show pool_nodes;</div>
<div>> node_id | hostname | port | status | lb_weight | role | select_cnt |</div>
<div>> load_balance_node | replication_delay</div>
<div>> ---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------</div>
<div>> 0 | 10.0.58.124 | 5432 | up | 0.250000 | primary | 0 |</div>
<div>> true | 0</div>
<div>> 1 | 10.0.58.123 | 5433 | down | 0.250000 | standby | 0 |</div>
<div>> false | 0</div>
<div>> 2 | 10.0.58.130 | 5433 | unused | 0.250000 | standby | 0 |</div>
<div>> false | 0</div>
<div>> 3 | 10.0.58.132 | 5433 | unused | 0.250000 | standby | 0 |</div>
<div>> false | 0</div>
<div>> (4 registros)</div>
<div>> </div>
<div>> </div>
<div>> Then i maked a shell script for for mass execution of querys, but executed</div>
<div>> on the master only (node_id 0).</div>
<div>> </div>
<div>> </div>
<div>> relevant parts of the configuration</div>
<div>> ----------------------------------------------------------------</div>
<div>> backend_hostname0 = '10.0.58.124'</div>
<div>> backend_port0 = 5432</div>
<div>> backend_weight0 = 1</div>
<div>> backend_data_directory0 = '/storage1/data'</div>
<div>> backend_flag0 = 'ALWAYS_MASTER'</div>
<div>> </div>
<div>> backend_hostname1 = '10.0.58.123'</div>
<div>> backend_port1 = 5433</div>
<div>> backend_weight1 = 1</div>
<div>> backend_data_directory1 = '/storage1/data'</div>
<div>> backend_flag1 = 'ALLOW_TO_FAILOVER'</div>
<div>> </div>
<div>> backend_hostname2 = '10.0.58.130'</div>
<div>> backend_port2 = 5433</div>
<div>> backend_weight2 = 1</div>
<div>> backend_data_directory2 = '/storage1/data'</div>
<div>> backend_flag2 = 'ALLOW_TO_FAILOVER'</div>
<div>> </div>
<div>> backend_hostname3 = '10.0.58.132'</div>
<div>> backend_port3 = 5433</div>
<div>> backend_weight3 = 1</div>
<div>> backend_data_directory3 = '/storage1/data'</div>
<div>> backend_flag3 = 'ALLOW_TO_FAILOVER'</div>
<div>> </div>
<div>> load_balance_mode = on</div>
<div>> master_slave_mode = on</div>
<div>> master_slave_sub_mode = 'stream'</div>
<div>> ----------------------------------------------------------------</div>
<div>> </div>
<div>> </div>
<div>> Any Tips ?</div>
<div>> </div>
<div>> </div>
<div>> -- </div>
<div>> foobar</div>
<div> </div>
<div> </div>
<div>------------------------------</div>
<div> </div>
<div>_______________________________________________</div>
<div>pgpool-general mailing list</div>
<div>pgpool-general@pgpool.net</div>
<div>http://www.pgpool.net/mailman/listinfo/pgpool-general</div>
<div> </div>
<div> </div>
<div>End of pgpool-general Digest, Vol 85, Issue 17</div>
<div>**********************************************</div>
<div> </div>
<div> </div>
</div></blockquote>
</body></html>