pg10@pghost4->psql -h 10.10.10.15 -p 9999 postgres pg10 Password for user pg10: psql (10.0) Type “help” for help. postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---±---±---±---...
成功执行完pcp_recovery_node后,检查从节点是否正确加入集群: psql -h192.168.0.5 -p9999-U pgpool postgres -c"show pool_nodes"Password for user pgpool node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | rep...
Password for user pg10: psql (10.0) Type "help" for help. postgres=# show pool_nodes; node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | pghost4 | 1921 | down | ...
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change ---+---+---+---+---+---+---+---+---+---+---+--- 0 | 172.72...
load_balance_mode = on ignore_leading_white_space = on white_function_list = '' black_function_list = 'nextval,setval' 现在让我们来详细讨论这些设置,看看每个设置的意义: • pid_file_name: 就像大多数软件组件一样,pgpool会写一个PID文件。我们可以精确地定义这个文件的位置。通常PID文件处于/var/目...
load_balance_mode = on ignore_leading_white_space = on white_function_list = '' black_function_list = 'nextval,setval' 现在让我们来详细讨论这些设置,看看每个设置的意义: • pid_file_name: 就像大多数软件组件一样,pgpool会写一个PID文件。我们可以精确地定义这个文件的位置。通常PID文件处于/var/目...
用户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...
. 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 ---+---+---+---+---+---+---+---+---+--- 0 | /tmp | 11002 | up |...
$ 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---+---+---+---+---+---+---+---+---+---0 | /tmp | 11002 | up | 0.500000 | primary | 0 ...
node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---+---+---+---+---+---+---+---+--- 0 | master | 5432 | up | 0.500000 | primary | 0 | true | 0 1 | slave | 5432 | up | 0.500000 | standby...