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

[Tatsuo Ishii]

> 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