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?
[EMAIL PROTECTED] ~]#
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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
