[pgpool-general: 9349] Re: pgpool 4.5.5 can't reach stand by server

[Mauricio Fernandez]

Thanks Tatsuo for the tips, but it doesn't work for me

>From the master node (192.168.0.160) I can connect to the server1, the
stand by server

[postgres at buda pgpool-II]$ psql -h 192.168.0.162 -U postgres -p 5434
Contraseña para usuario postgres:
psql (17.2)
Digite «help» para obtener ayuda.
postgres=# \q

[postgres at buda pgpool-II]$ pcp_attach_node -p 9898 -h 192.168.0.162 -n 1 -U
postgres
ERROR: connection to host "192.168.0.162" failed with error "No route to
host"

In pgpool.con, the pcp parameters are:

pcp_listen_addresses = '*'
 #pcp_port = 9898
 pcp_socket_dir = '/var/run/postgresql'
 #log_pcp_processes = on

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.

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
https://oraclelinux.pkgs.org/9/ol9-codeready-builder-x86_64/libmemcached-awesome-1.1.0-12.el9.x86_64.rpm.html

 dnf install ./libmemcached-awesome-1.1.0-12.el9.x86_64.rpm

After installing the library and editing
/etc/yum.repos.d/pgdg-redhat-all.repo adding exclude=pgpool* in each
postgresql section
I could install pgpool.

Kind regards

Mauricio Fernández










El lun, 10 feb 2025 a las 22:40, Tatsuo Ishii (<ishii at postgresql.org>)
escribió:

> > Hi Tatsuo, thanks you for your interest
> >
> > The node 1 hostname is 192.168.1.162 but this do not match
> >> backend_hostname1 = '192.168.0.162'
> >
> > Which one is correct? The correct one is 192.168.0.162
> >
> > [postgres at buda ~]$ psql -p 9999 -U postgres
> > psql (17.2)
> > Digite «help» para obtener ayuda.
> >
> > postgres=# show pool_nodes;
> >  node_id |   hostname    | port | status | pg_status | lb_weight |  role
> > | pg_role | select_cnt | load_balance_node | replication_
> > delay | replication_state | replication_sync_state | last_status_change
> >
> ---------+---------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------
> > ------+-------------------+------------------------+---------------------
> >  0       | localhost     | 5434 | up     | up        | 0.000000  |
> primary
> > | primary | 0          | true              | 0
> >       |                   |                        | 2025-02-10 21:44:21
> >  1       | 192.168.0.162 | 5434 | down   | up        | 1.000000  |
> standby
> > | standby | 0          | false             | 0
> >       |                   |                        | 2025-02-10 21:44:21
> > (2 filas)
>
> Good. Now you should be able to make the standby online by using pcp
> command:
>
> pcp_attach_node -p 9898 -h localhost 1
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS K.K.
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20250211/de47a056/attachment.htm>