PGPool II does not recognize backend_server0 - Mailing list pgsql-general

From Pablo Calientos
Subject PGPool II does not recognize backend_server0
Date
Msg-id CA+BBeFCAHRj3PTTi3shWdpLyMK7KPP+eAs63TYgmfLK_6Backg@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi all,
I'm new to pgpool, I'm testing from scratch with version
[postgres@pgpool-01 ~]$ pgpool --version
pgpool-II version 4.6.2 (chirikoboshi)

I'm following the ufficial guide at https://www.pgpool.net/docs/latest/en/html/example-basic.html.
I started testing native replication mode, I use this configuration in virtualbox VMs:

server pgppol 192.168.1.118 OEL 9.6
server post01 192.168.1.116 OEL 9.6
server post02 192.168.1.117 OEL 9.6

All VMs can ping/telnet between them, from server pgpool I can connect to others postgres server via psql:

[postgres@pgpool-01 ~]$ psql -h 192.168.1.116
psql (13.20)
Type "help" for help.

postgres=# \q
[postgres@pgpool-01 ~]$ psql -h 192.168.1.117
psql (13.20)
Type "help" for help.

postgres=#

The relevant parameters in pgpool.conf are the following:

backend_clustering_mode = 'native_replication'

backend_hostname0 = '192.168.1.116'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/PGDATA'
backend_application_name0 = 'server0'

backend_hostname1 = '192.168.1.117'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/PGDATA'
backend_application_name1 = 'server1'

following the guide I sent creation for a database "test" from pgpool:

[postgres@pgpool-01 ~]$ createdb -p 9999 test

but the db has been created only in backend_hostname1.
IN fact pgpool report as down backend_hostname0:


[postgres@pgpool-01 ~]$ psql -h localhost -p 9999
psql (13.20)
Type "help" for help.

postgres=# show pool_nodes;
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_no
de | replication_delay | replication_state | replication_sync_state | last_status_change
---------+---------------+------+--------+-----------+-----------+---------+---------+------------+----------------
---+-------------------+-------------------+------------------------+---------------------
0 | 192.168.1.116 | 5432 | down | unknown | 0.500000 | replica | replica | 0 | false
| 0 | | | 2025-06-19 16:28:12
1 | 192.168.1.117 | 5432 | up | unknown | 0.500000 | main | main | 0 | true
| 0 | | | 2025-06-19 16:28:12
(2 rows)


But I dont see errors in configuration. If I change the backend server, switching the IP addresses (to be sure there are not
network or access misconfiguration) the server down results always the same backend_hostname0, I mean the problem is not in
the postgres server (changing IP does not change the status of show pool_nodes):

new configurazion:

backend_hostname0 = '192.168.1.117' <<< switched IP
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/PGDATA'
backend_application_name0 = 'server0'

backend_hostname1 = '192.168.1.116' <<< switched IP
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/PGDATA'
backend_application_name1 = 'server1'

reboot pgpopol and resent show pool_nodes:

[postgres@pgpool-01 ~]$ pgpool stop
2025-06-19 16:44:23.112: main pid 6247: LOG: stop request sent to pgpool (pid: 6124). waiting for termination...
.done.
[1]+ Done pgpool -n

[postgres@pgpool-01 ~]$ pgpool -n &
[1] 6248
[postgres@pgpool-01 ~]$ 2025-06-19 16:44:31.934: main pid 6248: LOG: reading status file: 0 th backend is set to down status
2025-06-19 16:44:31.934: main pid 6248: LOG: reading status file: 1 th backend is set to up status
2025-06-19 16:44:31.935: main pid 6248: LOG: redirecting log output to logging collector process
2025-06-19 16:44:31.935: main pid 6248: HINT: Future log output will appear in directory "/var/log/pgpool_log".

[postgres@pgpool-01 ~]$ psql -h localhost -p 9999
psql (13.20)
Type "help" for help.

postgres=# show pool_nodes;
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_no
de | replication_delay | replication_state | replication_sync_state | last_status_change
---------+---------------+------+--------+-----------+-----------+---------+---------+------------+----------------
---+-------------------+-------------------+------------------------+---------------------
0 | 192.168.1.117 | 5432 | down | unknown | 0.500000 | replica | replica | 0 | false
| 0 | | | 2025-06-19 16:44:31
1 | 192.168.1.116 | 5432 | up | unknown | 0.500000 | main | main | 0 | true
| 0 | | | 2025-06-19 16:44:31
(2 rows)

postgres=#

I cannot understand what I'm missing.
Any advice is welcome.

thanks in advance.

MP

pgsql-general by date:

Previous
From: raphi
Date:
Subject: Re: password rules
Next
From: Dmitry
Date:
Subject: Re: IPC/MultixactCreation on the Standby server