<div dir="ltr"><div>I changed both machine type to "rhel 6 x 64 "and configured pgpool for two servers but It still error.<br></div><div><div>When I start pgpool, in log file, I just see it find primary in node id = 0 without node = 1. Until I run "psql -h localhost -p 9999 -d postgres" , it raise error (if I just start pgpool , the log will show as below).</div><div><br></div><div>2015-03-05 16:22:52: pid 30045: LOG: Setting up socket for 0.0.0.0:99992015-03-05 16:22:52: pid 30045: LOG: Setting up socket for :::99992015-03-05 16:22:52: pid 30045: LOG: pgpool-II successfully started. version 3.4.0 (tataraboshi)2015-03-05 16:22:52: pid 30045: LOG: find_primary_node: checking backend no 02015-03-05 16:22:52: pid 30045: LOG: find_primary_node: primary node id is 0<br><br></div><div><br></div><div>Here pgpool log when I debug:<div><br></div></div></div><div>2015-03-05 16:44:35: pid 30758: LOG: find_primary_node: primary node id is 0<br>2015-03-05 16:44:45: pid 30790: DEBUG: I am 30790 accept fd 62015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet2015-03-05 16:44:45: pid 30790: DETAIL: Protocol Major: 1234 Minor: 5679 database: user: 2015-03-05 16:44:45: pid 30790: DEBUG: selecting backend connection2015-03-05 16:44:45: pid 30790: DETAIL: SSLRequest from client2015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet2015-03-05 16:44:45: pid 30790: DETAIL: application_name: psql2015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet2015-03-05 16:44:45: pid 30790: DETAIL: Protocol Major: 3 Minor: 0 database: postgres user: enterprisedb2015-03-05 16:44:45: pid 30790: DEBUG: creating new connection to backend2015-03-05 16:44:45: pid 30790: DETAIL: connecting 0 backend2015-03-05 16:44:45: pid 30790: DEBUG: creating new connection to backend2015-03-05 16:44:45: pid 30790: DETAIL: connecting 1 backend2015-03-05 16:44:45: pid 30790: DEBUG: reading message length2015-03-05 16:44:45: pid 30790: DETAIL: slot: 0 length: 122015-03-05 16:44:45: pid 30790: DEBUG: reading message length2015-03-05 16:44:45: pid 30790: DETAIL: slot: 1 length: 82015-03-05 16:44:45: pid 30790: ERROR: unable to read message length2015-03-05 16:44:45: pid 30790: DETAIL: message length (8) in slot 1 does not match with slot 0(12)</div><div><br></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Mar 5, 2015 at 5:43 PM, Luan Huynh <span dir="ltr"><<a href="mailto:onlinegvn9x@gmail.com" target="_blank">onlinegvn9x@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hi all , <br><div><span style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium"><br></span></div><div><font color="#000000" face="Times New Roman" size="3">I am newbie in pgpool II 3.4.1</font></div><div><font color="#000000" face="Times New Roman" size="3"><br></font></div><div>My configuration:</div><div>+ master machine : centos 6 x64, postgresql 9.3, pgpool II 3.4.1</div><div>+ slave machine : redhat 6 x64 , postgresql 9.3 </div><div>+ master-slave is configured streaming replication together </div><div>+ ssh between master - slave is ok .</div><div><br></div><div>After starting pgpool and try connect to database via port 9999, I get log:</div><div><br></div><div><div>2015-03-05 09:43:35: pid 6821: LOG: Setting up socket for <a href="http://0.0.0.0:9999" target="_blank">0.0.0.0:9999</a></div><div>2015-03-05 09:43:35: pid 6821: LOG: Setting up socket for :::9999</div><div>2015-03-05 09:43:35: pid 6821: LOG: pgpool-II successfully started. version 3.4.0 (tataraboshi)</div><div>2015-03-05 09:43:35: pid 6821: LOG: find_primary_node: checking backend no 0</div><div><br></div><div>2015-03-05 09:43:35: pid 6821: LOG: find_primary_node: primary node id is 0</div><div>2015-03-05 09:45:49: pid 6853: LOG: new connection received</div><div>2015-03-05 09:45:49: pid 6853: DETAIL: connecting host=::1 port=43040</div><div>2015-03-05 09:45:49: pid 6853: ERROR: unable to read message length</div><div>2015-03-05 09:45:49: pid 6853: DETAIL: message length (8) in slot 1 does not match with slot 0(12)</div><div>2015-03-05 09:48:41: pid 6852: LOG: new connection received</div><div>2015-03-05 09:48:41: pid 6852: DETAIL: connecting host=::1 port=43061</div><div>2015-03-05 09:48:41: pid 6852: ERROR: unable to read message length</div><div>2015-03-05 09:48:41: pid 6852: DETAIL: message length (8) in slot 1 does not match with slot 0(12)</div><div>2015-03-05 09:51:01: pid 6853: LOG: new connection received</div><div>2015-03-05 09:51:01: pid 6853: DETAIL: connecting host=::1 port=43078</div><div>2015-03-05 09:51:02: pid 6853: ERROR: unable to read message length</div><div>2015-03-05 09:51:02: pid 6853: DETAIL: message length (8) in slot 1 does not match with slot 0(12)</div><div>2015-03-05 09:51:05: pid 6853: LOG: new connection received</div><div>2015-03-05 09:51:05: pid 6853: DETAIL: connecting host=::1 port=43084</div><div>2015-03-05 09:51:05: pid 6853: ERROR: unable to read message length</div><div>2015-03-05 09:51:05: pid 6853: DETAIL: message length (8) in slot 1 does not match with slot 0(12)</div><div> </div></div><div>I search on google and found website <a href="http://code.metager.de/source/xref/postgresql/pgpool2/src/auth/pool_auth.c" target="_blank">http://code.metager.de/source/xref/postgresql/pgpool2/src/auth/pool_auth.c</a> to show code but I do not know clearly my problems. Please give me some solutions or point me what I am wrong .</div><div><br></div><div><br></div><div>Thanks .</div><div><br></div><div><br></div><div><br></div></div>
</blockquote></div><br></div></div>