[pgpool-general: 5280] No more master role in psql show pool nodes

[Daniel Huhardeaux]

Hi,

I face following problem after a restart, it was working well since 4 
monthes, no configuration changes.

Node 0 should have role master! How to change role to master for node 
0/tooi-as-0005 ?

Version: pgpool-II version 3.6.0 (subaruboshi) from Ubuntu 16.04.1

Thanks for any hint.


on node 0

psql show pool nodes:

  node_id |   hostname   | port  | status | lb_weight | role   | 
select_cnt | load_balance_node | replication_delay
---------+--------------+-------+--------+-----------+---------+------------+-------------------+-------------------
  0       | tooi-as-0005 | 55432 | up     | 0.500000  | standby | 
17308      | false             | 0
  1       | tooi-as-0006 | 55432 | up     | 0.500000  | standby | 
9001       | true              | 0
(2 lignes)

postgres=# select pg_is_in_recovery();
  pg_is_in_recovery
-------------------
  f
(1 ligne)


on node 1

psql show pool nodes:

  node_id |   hostname   | port  | status | lb_weight |  role   | 
select_cnt | load_balance_node | replication_delay
---------+--------------+-------+--------+-----------+---------+------------+-------------------+-------------------
  0       | tooi-as-0005 | 55432 | up     | 0.500000  | standby | 17309 
      | true              | 0
  1       | tooi-as-0006 | 55432 | up     | 0.500000  | standby | 
9001       | false             | 0
(2 lignes)

postgres=# select pg_is_in_recovery();
  pg_is_in_recovery
-------------------
  t
(1 ligne)

-- 
Daniel
TOOTAi Networks