[Pgpool-general] node status codes

[Marcelo Martins]

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
pglists at zeroaccess.org
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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general