<div dir="ltr">Thanks Tatsuo for the tips, but it doesn't work for me<div><br></div><div>From the master node (192.168.0.160) I can connect to the server1, the stand by server</div><div><br></div><div>[postgres@buda pgpool-II]$ psql -h 192.168.0.162 -U postgres -p 5434<br>Contraseña para usuario postgres: <br>psql (17.2)<br>Digite «help» para obtener ayuda.<br>postgres=# \q<br><br></div><div>[postgres@buda pgpool-II]$ pcp_attach_node -p 9898 -h 192.168.0.162 -n 1 -U postgres<br>ERROR: connection to host "192.168.0.162" failed with error "No route to host"<br></div><div><br></div><div>In pgpool.con, the pcp parameters are:</div><div><br></div><div>pcp_listen_addresses = '*'<br> #pcp_port = 9898<br> pcp_socket_dir = '/var/run/postgresql'<br> #log_pcp_processes = on</div><div><br></div><div>Even if the attaching process would work, I don't understand why it is necessary and pgpool don't try to reach stand by server at the starting up time.</div><div><br></div><div>By de the way, for me was not easy install pgpool. The process failed because inexistent library libmemcached.so.11. After a while I could reach the correct rpm from <a href="https://oraclelinux.pkgs.org/9/ol9-codeready-builder-x86_64/libmemcached-awesome-1.1.0-12.el9.x86_64.rpm.html">https://oraclelinux.pkgs.org/9/ol9-codeready-builder-x86_64/libmemcached-awesome-1.1.0-12.el9.x86_64.rpm.html</a></div><br> dnf install ./libmemcached-awesome-1.1.0-12.el9.x86_64.rpm<div><br></div><div>After installing the library and editing /etc/yum.repos.d/pgdg-redhat-all.repo adding exclude=pgpool* in each postgresql section</div><div>I could install pgpool.</div><div><br></div><div>Kind regards</div><div><br></div><div>Mauricio Fernández<br><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div> </div><div><br></div><div><br></div></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">El lun, 10 feb 2025 a las 22:40, Tatsuo Ishii (<<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> Hi Tatsuo, thanks you for your interest<br>
> <br>
> The node 1 hostname is 192.168.1.162 but this do not match<br>
>> backend_hostname1 = '192.168.0.162'<br>
> <br>
> Which one is correct? The correct one is 192.168.0.162<br>
> <br>
> [postgres@buda ~]$ psql -p 9999 -U postgres<br>
> psql (17.2)<br>
> Digite «help» para obtener ayuda.<br>
> <br>
> postgres=# show pool_nodes;<br>
> node_id | hostname | port | status | pg_status | lb_weight | role<br>
> | pg_role | select_cnt | load_balance_node | replication_<br>
> delay | replication_state | replication_sync_state | last_status_change<br>
> ---------+---------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------<br>
> ------+-------------------+------------------------+---------------------<br>
> 0 | localhost | 5434 | up | up | 0.000000 | primary<br>
> | primary | 0 | true | 0<br>
> | | | 2025-02-10 21:44:21<br>
> 1 | 192.168.0.162 | 5434 | down | up | 1.000000 | standby<br>
> | standby | 0 | false | 0<br>
> | | | 2025-02-10 21:44:21<br>
> (2 filas)<br>
<br>
Good. Now you should be able to make the standby online by using pcp<br>
command:<br>
<br>
pcp_attach_node -p 9898 -h localhost 1<br>
<br>
Best reagards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS K.K.<br>
English: <a href="http://www.sraoss.co.jp/index_en/" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en/</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div>