[pgpool-general: 2412] watchdog: different statuses on different pgpool nodes.

Sergey Arlashin sergeyarl.maillist at gmail.com
Wed Jan 15 17:44:40 JST 2014


Hi!

I'm trying set up watchdog and cannot figure out why sometimes I get different statuses on different pgpool nodes. It looks like this:

Two nodes : pgpool-node1and pgpool-node2. Watchdog mutual IP address is currently assigned to pgpool-node1. 

pgpool-node1:~# psql -U postgres -h watchdog.mutual-ip -p 9999

Password for user postgres:
psql (9.3.2)
Type "help" for help.

postgres=# show pool_nodes;
 node_id |   hostname    | port | status | lb_weight |  role
---------+---------------+------+--------+-----------+---------
 0       | db-node1.site | 5432 | 2      | 0.500000  | primary
 1       | db-node2.site | 5432 | 2      | 0.500000  | standby
(2 rows)



pgpool-node2:~# psql -U postgres -h localhost -p 9999
Password for user postgres:
psql (9.3.2)
Type "help" for help.

postgres=# show pool_nodes;
 node_id |   hostname    | port | status | lb_weight |  role
---------+---------------+------+--------+-----------+---------
 0       | db-node1.site | 5432 | 2      | 0.500000  | primary
 1       | db-node2.site | 5432 | 3      | 0.500000  | standby
(2 rows)

I cannot see any problems in pgpool logs. Or any other indication that something goes wrong. 

Could you please tell me why this could happen? 


Thanks in advance.

--
Best regards,
Sergey Arlashin




More information about the pgpool-general mailing list