[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