<div dir="ltr">Hi Ishii, <div><br></div><div>I can connect perfectly with </div><div><span style="font-size:12.8px"><font face="monospace, monospace" color="#000000">psql -p 9999 -hvdiccs01 postgres</font></span></div><div><font face="monospace, monospace" color="#000000"><br></font></div><div><div><font face="monospace, monospace" color="#000000">postgres=# SHOW pool_nodes;</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: processing frontend response</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DETAIL: received kind 'Q'(51) from frontend</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: session context: clearing doing extended query messaging. DONE</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: session context: setting query in progress. DONE</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: SimpleQuery</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DETAIL: nodes reporting</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: session context: unsetting query in progress. DONE</font></div><div><font face="monospace, monospace" color="#000000">2016-10-30 04:25:01: pid 23968: DEBUG: session context: setting skip reading from backends. DONE</font></div><div><font face="monospace, monospace" color="#000000"> node_id | hostname | port | status | lb_weight | role | select_cnt</font></div><div><font face="monospace, monospace" color="#000000">---------+----------+------+--------+-----------+--------+------------</font></div><div><font face="monospace, monospace" color="#000000"> 0 | vdiccs01 | 5432 | 2 | 0.333333 | master | 1</font></div><div><font face="monospace, monospace" color="#000000"> 1 | vdiccs02 | 5432 | 3 | 0.333333 | slave | 0</font></div><div><font face="monospace, monospace" color="#000000"> 2 | vdiccs03 | 5432 | 3 | 0.333333 | slave | 0</font></div><div><font face="monospace, monospace" color="#000000">(3 rows)</font></div></div><div><br></div><div>pgpool version:</div><div><br></div><div>pgpool-II-96.x86_64 3.5.4-1.rhel7 @pgdg96<br></div><div><br></div><div>Related to logs, </div><div><br></div><div><div><font face="monospace, monospace">bench_replication=# insert into t1 values (4);</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: processing frontend response</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: received kind 'Q'(51) from frontend</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: clearing doing extended query messaging. DONE</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: setting query in progress. DONE</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: make table name from rangevar: tablename:""t1""</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_write: to backend: 0 kind:Q</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: waiting for query response</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: waiting for backend:0 to complete the query</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_read: read 22 bytes from backend 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: detect error: kind: C</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: detect error: kind: C</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: detect error: kind: C</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: detect error: kind: C</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_use_sync_map: we cannot use sync map because STREAM: 0 query in progress: 1 doing extended query: 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: reading backend data packet kind</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: backend:0 of 3 kind = 'C'</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: read_kind_from_backend max_count:1.000000 num_executed_nodes:1</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: processing backend response</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: received kind 'C'(43) from backend</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: setting command success. DONE</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_use_sync_map: we cannot use sync map because STREAM: 0 query in progress: 1 doing extended query: 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: reading backend data packet kind</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: backend:0 of 3 kind = 'Z'</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: read_kind_from_backend max_count:1.000000 num_executed_nodes:1</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: processing backend response</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: received kind 'Z'(5a) from backend</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: processing backend response</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: Ready For Query received</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: clearing ignore till sync. DONE</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_use_sync_map: we cannot use sync map because STREAM: 0 query in progress: 1 doing extended query: 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_use_sync_map: we cannot use sync map because STREAM: 0 query in progress: 1 doing extended query: 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: pool_use_sync_map: we cannot use sync map because STREAM: 0 query in progress: 1 doing extended query: 0</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: reading message length</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: slot: 0 length: 5</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: processing ReadyForQuery</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DETAIL: transaction state 'I'(49)</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: unsetting query in progress. DONE</font></div><div><font face="monospace, monospace">2016-10-30 04:33:47: pid 23957: DEBUG: session context: unsetting query in progress. DONE</font></div><div><font face="monospace, monospace">INSERT 0 1<br></font></div></div><div><br></div><div>Thanks a lot.<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-10-30 23:30 GMT+01:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">> Hi,<br>
><br>
> In my environment I have 3 nodes (vdiccs01, vdiccs02 and vdiccs03). I have<br>
> installed pgpool in all nodes for testing purposes but I'm planning to use<br>
> just the pgpool daemon runing on vdicss01.<br>
><br>
> I'm following step by step the tutorial that is available on the web:<br>
><br>
> <a href="http://www.pgpool.net/docs/latest/tutorial-en.html#replication" rel="noreferrer" target="_blank">http://www.pgpool.net/docs/<wbr>latest/tutorial-en.html#<wbr>replication</a><br>
><br>
> In the step:<br>
><br>
> createdb -p 9999 -hvdiccs01 bench_replication<br>
><br>
> I have expected that the database creation to be executed in all nodes<br>
> because I have set to true the replication_mode = true nevertheless, the<br>
> bench_replication is only created in node vdicss01.<br>
><br>
> I'm very new and I supose I'm not understanding perfectly the correct way<br>
> of working of pgpool.<br>
><br>
> Any help will be welcome to understand what's happening.<br>
><br>
> Thanks a lot.<br>
<br>
</div></div>psql -p 9999 -hvdiccs01 postgres<br>
<br>
will show what are the status of vdiccs01, vdiccs02 and vdiccs03<br>
recognized by Pgpool-II. I guess Pgpool-II does not think vdiccs02 and<br>
vdiccs03 are online. Also you'd better tell what version of Pgpool-II<br>
you are using along with pgool.conf and Pgpool-II log.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br></div>