* The first DB node id appears in pgpool.conf or the first "live" DB * node otherwise. */ #define REAL_MASTER_NODE_ID (Req_info->master_node_id) /* * The primary node id in streaming replication mode. If not in the * mode or there's no primary node, this macro returns * REA...
需要在每个节点机的/home/postgresql/pgpool/etc目录下创建一个节点文件pgpool_node_id用于标识节点ID,以便看门狗识别每个节点,每个节点ID不能相同。 [server1]# cat /etc/pgpool-II/pgpool_node_id0[sever2]# cat /etc/pgpool-II/pgpool_node_id1[server3]# cat /etc/pgpool-II/pgpool_node_id2 1.2 Pgpo...
DEST_NODE_HOST="$2"# 参数3 - 目的节点PGDATA目录DEST_NODE_PGDATA="$3"# 参数4 - 主节点端口号PRIMARY_NODE_PORT="$4"# 参数5 - 目的节点ID(对应etc目录下的pgpool_node_id文件内容)DEST_NODE_ID="$5"# 参数6 - 目的节点端口号DEST_NODE_PORT="$6"...
show pool_nodes; 悲剧的是主库居然pgpool 状态为down,也就是日志说的node 0 0,正常应该node 0 2; 反复检查参数配置没有错,于是执行(一般主备库重启后,状态异常可以执行以下语句): pcp_attach_node -h 192.168.10.61 -U pgpool 0 注意,0为节点1,如果是备库有问题,就是pcp_attach_node -h 192.168.10.61...
pcp_attach_node -d -U postgres -h vip -p 9898 -n 0 # 6. 此时 node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | master | 5432 | up | 0.500000 | standby | 0...
# special values: %d = node id # %h = host name # %p = port number # %D = database cluster path # %m = new master node id # %M = old master node id # %% = '%' character # failover_command ='' # Execute command by failback. ...
# %d = node id # %h = host name # %p = port number # %D = database cluster path # %m = new master node id # %H = hostname of the new master node # %M = old master node id # %P = old primary node id # %r = new master port number ...
用户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|01|192.168.36.131|5432|up|0.500000|standby|0|true|0(2rows...
[postgres@master data]$ pcp_attach_node -d -U postgres -h 10.1.83.168 -p 9898 -n 0 #注意master的node_id是0,所以-n 0 Password: #提示输入密码,输入pcp管理密码。 DEBUG: recv: tos="m", len=8 DEBUG: recv: tos="r", len=21
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | pghost4 | 1921 | down | -nan | standby | 0 | false | 0 1 | pghost5 | 1921 | up | -nan | ...