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

[Tatsuo Ishii]

Well, Pgpool-II 3.6.0 was realesed on last November. So it has been
there for just 2 months and 8 days. Maybe you see the problem after
upgrading to 3.6.0?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general