[Pgpool-general] pcp_node_info question

[open]

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 :)
>
>