<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Hi Tatsuo,<br></div><div class="gmail_default" style="font-family:verdana,sans-serif">your hypothesis was exact. After deleting pgpool_status file 'show pool_nodes' returns this output:</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default"><div class="gmail_default"><font face="monospace, monospace"> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay</font></div><div class="gmail_default"><font face="monospace, monospace">---------+-------------------------+-------+--------+-----------+---------+------------+-------------------+-------------------</font></div><div class="gmail_default"><font face="monospace, monospace"> 0 | <a href="http://citrix2.redevogames.com">citrix2.redevogames.com</a> | 15004 | up | 0.250000 | primary | 1 | false | 0</font></div><div class="gmail_default"><font face="monospace, monospace"> 1 | 10.0.0.3 | 5997 | up | 0.750000 | standby | 2 | true | 0</font></div><div style="font-family:verdana,sans-serif"><br></div><div style="font-family:verdana,sans-serif"><br></div><div style="font-family:verdana,sans-serif">For completeness, in debian standard installation pgpool_status is located in this path:</div><div style="font-family:verdana,sans-serif"><br></div><div><font face="verdana, sans-serif">/var/log/postgresql/</font><br></div><div style="font-family:verdana,sans-serif"><br></div></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_default" style="font-family:verdana,sans-serif">Thank you very much for your help.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Meph</div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On 15 March 2017 at 00:25, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">It is possible that Pgpool-II server is looking into the old status<br>
file ("pgpool_status"). After stopping Pgpool-II server, remove the<br>
file and restart Pgpool-II. The location of pgpool_status varies to<br>
the installation. I'm not familiar with Pgpool-II debian package, but<br>
you could find the location by looking at "logdir" directive in the<br>
pgpool.conf. If logdir is not found in pgpool.conf, try to locate it<br>
by using "pgpool show logdir".<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>
<div class="gmail-HOEnZb"><div class="gmail-h5"><br>
> Hi there,<br>
> I installed pgpool-II 3.6.1 by debian package from postgres repository. I<br>
> copied configuration from old installation from source on other debian<br>
> server.<br>
> A the moment I don't understand the status of my pool:<br>
><br>
> node_id | hostname | port | status | lb_weight | role |<br>
> select_cnt | load_balance_node | replication_delay<br>
> ---------+--------------------<wbr>-----+-------+--------+-------<wbr>----+---------+------------+--<wbr>-----------------+------------<wbr>-------<br>
> 0 | <a href="http://citrix2.redevogames.com" rel="noreferrer" target="_blank">citrix2.redevogames.com</a> | 15004 | up | <a href="tel:0.250000" value="+390250000">0.250000</a> | primary |<br>
> 15 | true | 0<br>
> 1 | 10.0.0.3 | 5997 | unused | 0.750000 | standby |<br>
> 0 | false | 0<br>
><br>
><br>
><br>
> This is my configurationç<br>
><br>
> backend_hostname0 = '<a href="http://citrix2.redevogames.com" rel="noreferrer" target="_blank">citrix2.redevogames.com</a>'<br>
> backend_port0 = 15004<br>
> backend_weight0 = 0.25<br>
> backend_data_directory0 = '/opt/postgres/dataclusters/<wbr>redevodb_test'<br>
> backend_flag0 = 'ALLOW_TO_FAILOVER'<br>
><br>
> backend_hostname1 = '10.0.0.3'<br>
> backend_port1 = 5997<br>
> backend_weight1 = 0.75<br>
> backend_data_directory1 = '/opt/postgres/dataclusters/<wbr>redevodb'<br>
> backend_flag1 = 'ALLOW_TO_FAILOVER'<br>
><br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
> # CONNECTION POOLING<br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
><br>
> connection_cache = on<br>
> # Activate connection pools<br>
> # (change requires restart)<br>
><br>
> # Semicolon separated list of queries<br>
> # to be issued at the end of a session<br>
> # The default is for 8.3 and later<br>
> reset_query_list = 'ABORT; DISCARD ALL'<br>
> # The following one is for 8.2 and before<br>
> #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<br>
><br>
><br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
> # REPLICATION MODE<br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
><br>
> replication_mode = off<br>
> # Activate replication mode<br>
> # (change requires restart)<br>
> replicate_select = off<br>
> # Replicate SELECT statements<br>
> # when in replication mode<br>
> # replicate_select is higher priority<br>
> than<br>
> # load_balance_mode.<br>
><br>
> insert_lock = on<br>
> # Automatically locks a dummy row or a<br>
> table<br>
> # with INSERT statements to keep SERIAL<br>
> data<br>
> # consistency<br>
> # Without SERIAL, no lock will be issued<br>
> lobj_lock_table = ''<br>
> # When rewriting lo_creat command in<br>
> # replication mode, specify table name to<br>
> # lock<br>
><br>
> # - Degenerate handling -<br>
><br>
> replication_stop_on_mismatch = off<br>
> # On disagreement with the packet kind<br>
> # sent from backend, degenerate the node<br>
> # which is most likely "minority"<br>
> # If off, just force to exit this session<br>
><br>
> failover_if_affected_tuples_<wbr>mismatch = off<br>
> # On disagreement with the number of<br>
> affected<br>
> # tuples in UPDATE/DELETE queries, then<br>
> # degenerate the node which is most<br>
> likely<br>
> # "minority".<br>
> # If off, just abort the transaction to<br>
> # keep the consistency<br>
><br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
> # LOAD BALANCING MODE<br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
><br>
> load_balance_mode = on<br>
> # Activate load balancing mode<br>
> # (change requires restart)<br>
> ignore_leading_white_space = on<br>
> # Ignore leading white spaces of each<br>
> query<br>
> white_function_list = 'get.*,check.*,is.*'<br>
> # Comma separated list of function names<br>
> # that don't write to database<br>
> # Regexp are accepted<br>
> black_function_list =<br>
> 'nextval,setval,nextval,<wbr>setval,database_control.*,add.<wbr>*,buy.*,change.*,create.*,<wbr>delete.*,do.*,exec.*,remove.*,<wbr>send.*,set.*,update.*,<wbr>generate.*'<br>
> # Comma separated list of function names<br>
> # that write to database<br>
> # Regexp are accepted<br>
><br>
> database_redirect_preference_<wbr>list = ''<br>
> # comma<br>
> separated list of pairs of database and node id.<br>
> #<br>
> example: postgres:primary,mydb[0-4]:1,<wbr>mydb[5-9]:2'<br>
> # valid<br>
> for streaming replicaton mode only.<br>
><br>
> app_name_redirect_preference_<wbr>list = ''<br>
> # comma<br>
> separated list of pairs of app name and node id.<br>
> #<br>
> example: 'psql:primary,myapp[0-4]:1,<wbr>myapp[5-9]:standby'<br>
> # valid<br>
> for streaming replicaton mode only.<br>
> allow_sql_comments = off<br>
> # if on,<br>
> ignore SQL comments when judging if load balance or<br>
> # query<br>
> cache is possible.<br>
> # If<br>
> off, SQL comments effectively prevent the judgment<br>
> # (pre<br>
> 3.4 behavior).<br>
><br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
> # MASTER/SLAVE MODE<br>
> #-----------------------------<wbr>------------------------------<wbr>-------------------<br>
><br>
> master_slave_mode = on<br>
> # Activate master/slave mode<br>
> # (change requires restart)<br>
> master_slave_sub_mode = 'stream'<br>
> # Master/slave sub mode<br>
> # Valid values are combinations slony or<br>
> # stream. Default is slony.<br>
> # (change requires restart)<br>
><br>
> # - Streaming -<br>
><br>
> sr_check_period = 10<br>
> # Streaming replication check period<br>
> # Disabled (0) by default<br>
> sr_check_user = 'postgres'<br>
> # Streaming replication check user<br>
> # This is necessary even if you disable<br>
> # streaming replication delay check with<br>
> # sr_check_period = 0<br>
><br>
><br>
> Why my standby node are note used? Are there some errors in configuration?<br>
><br>
> Can you help me plese?<br>
><br>
> Thanks in advance.<br>
><br>
><br>
> Meph<br>
</div></div></blockquote></div><br></div></div>