[Pgpool-general] pcp_node_info question

[open]

I resolve my problem. thx all

open wrote:
> thx for the quick answear, but.....
>
> pcp_node_info 10 127.0.0.1 5433 xxx xxx 3
> vps2203.mtu.immo 5432 3 536870911.750000
>
> pcp_node_info 10 127.0.0.1 5433 xxx xxx 2
> vps2202.mtu.immo 5432 3 536870911.750000
>
> pcp_node_info 10 127.0.0.1 5433 xxx xxx 1
> vps2197.mtu.immo 5432 3 536870911.750000
>
> pcp_node_info 10 127.0.0.1 5433 xxx xxx 0
> vps2196.mtu.immo 5432 3 536870911.750000
>
>
> psql -U postgres template1 -h vps2202.mtu.immo -c "Select 1"
>  ?column?
> ----------
>         1
> (1 row)
>
> psql -U postgres template1 -h vps2203.mtu.immo -c "Select 1"
> psql: could not connect to server: Connection refused
>         Is the server running on host "vps2203.mtu.immo" and accepting
>         TCP/IP connections on port 5432?
> [root at vps2195 ~]#
>
>
> another words, i have a one dead node (id=3) and three live node (id=0,1,2)
>
> but status = 3 .....
>
> Any ideas?
>
>
> Jaume Sabater wrote:
>   
>> open wrote:
>>
>>   
>>     
>>> pcp_node_info 10 127.0.0.1 5433 xxx yyy 3
>>> vps2203.mtu.immo 5432 3 536870911.750000
>>>     
>>>       
>> This information is correct as the third value, the status, means "Node is down".
>>
>>   
>>     
>>> ок, i detach fourth backand
>>> pcp_detach_node 10 127.0.0.1 5433 xxx yyy 3
>>> but nothing change...
>>>     
>>>       
>> The node was already detached due to the failover process that degenerated it.
>>
>>   
>>     
>>> Can i get actually info about DEAD and LIVE nodes ? how can i get it ?
>>>     
>>>       
>>
>> Hope this helps. Not sure if Tatsuo wants to add something else or correct my words :)
>>
>>   
>>     
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>