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? > [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 >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
