2 | 192.168.85.132 | 5432 | waiting | 0.333333 | slave | 0 | false | 0 停掉192.168.85.130 130服务器执行systemctl stop postgresql-9.5 postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---...
$ pg_ctl -D data1 stop waiting for server to shut down... done server stopped $ psql -p 11000 -c "show pool_nodes" test node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change ---+---+---+---+-...
postgres=> show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_syn c_state | last_status_change ---+---+---+---+---+---+---+---+---+---+--- ---+---...
CON_CONNECT_WAIT, /* waiting for connection starting */ CON_UP, /* up and running */ CON_DOWN /* down, disconnected */ } BACKEND_STATUS; /* backend status name strings */ #define BACKEND_STATUS_CON_UNUSED "unused" #define BACKEND_STATUS_CON_CONNECT_WAIT "waiting" #define BACKEND_STAT...
#define BACKEND_STATUS_CON_CONNECT_WAIT "waiting" #define BACKEND_STATUS_CON_UP "up" #define BACKEND_STATUS_CON_DOWN "down" PostgreSQL数据库在pgpool集群中的描述信息如下: /* * PostgreSQL backend descriptor. Placed on shared memory area.
$ pg_ctl -D data1 stopwaiting for server to shut down... doneserver stopped$ psql -p 11000 -c "show pool_nodes" testnode_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change---+---+---+---+---+--...
6. 此时node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | master | 5432 | up | 0.500000 | standby | 0 | false | 0 1 | slave | 5432 | up | 0.500000 | primary ...
El problema es que PGPOOL deja de ver al primario y lo marca con status = down pero en la columna pg_status, sigue marcado como UP. Esto ha ocurrido sin reiniciar el servicio de postgres en el nodo primario. Revise el log de REPMGR y Postgres, y no existe ninguna pérdida de servicio...
用户pgpool 的口令:postgres=> show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | 192.168.36.130 | 5432 | up | 0.500000 | primary | 0 |false| 0 1 |...
pgpool2_pool_nodes_status3.6+Backend node Status (1 for up or waiting, 0 for down or unused) pgpool2_pool_nodes_replication_delay3.6+Replication delay pgpool2_pool_nodes_select_cnt3.6+SELECT query counts issued to each backend pgpool2_pool_cache_cache_hit_ratio3.6+Query cache hit ratio ...