That is explained in the references section of the pgpool site. I posted a copy of that.
http://pgpool.projects.postgresql.org/#reference $ pcp_node_info 10 localhost 9898 postgres hogehoge 0 host1 5432 1 1073741823.500000 The result is in the following order: 1. hostname 2. port number 3. status 4. load balance weight Status is represented by a digit from [0 to 3]. 0 - This state is only used during the initialization. PCP will never display it. 1 - Node is up. No connections yet. 2 - Node is up. Connections are pooled. 3 - Node is down. Marcelo Linux/Solaris System Administrator [EMAIL PROTECTED] http://www.zeroaccess.org On Oct 9, 2008, at 5:23 PM, Brent Thomson wrote: > Can someone provide a description of the node status codes, as seen in > pgpool.log and in the results of pcp_node_info mean? It seems that 3 > means the node is detached. I can't tell what the difference between 1 > and 2 is, though. It appears that attached, healthy nodes can have > either status. > > -Brent > _______________________________________________ > 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
