[pgpool-general: 5282] Re: No more master role in psql show pool nodes
Daniel Huhardeaux
tech at tootai.net
Sat Jan 28 21:15:10 JST 2017
Le 28/01/2017 à 01:53, Tatsuo Ishii a écrit :
> 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?
What I meaned is that servers are installed and running since 4 monthes.
They where restarted since november, weekly security update.
[...]
>
>> 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
>
--
TOOTAi Networks
More information about the pgpool-general
mailing list