在关闭server1上的PG后,failover自动发生,节点3成为新的主库: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 [postgres@lhrpg30 ~]$ psql -h 172.72.6.35 -p 9999 -U pgpool postgres -c "show pool_nodes" node_id | hostname | port | status | pg_status | lb_weight | role | pg_role...
unix 2 [ ACC ] STREAM LISTENING 30967 - /tmp/.s.PGSQL.9898 使用pcp管理命令查看pgpool中间件状态 pcp_node_info -U pcpadm -p 9898 Password: 127.0.0.1 5432 2 0.200000 up unknown primary unknown 0 none none 2023-01-02 03:44:20 127.0.0.1 5433 2 0.400000 up unknown standby unknown 0 non...
$ 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 | replication_state | replication_sync_state | last_status_...
$k logs -f p-ha-postgresql-ha-pgpool-6c754f6857-mprtn -n ccspgpool 12:03:59.96pgpool 12:03:59.96 Welcome to the Bitnami pgpool containerpgpool 12:03:59.97 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-pgpoolpgpool 12:03:59.97 Submit issues and feature...
PRIMARY: ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string ---+---+---+---+---+---+---+---+---
node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_st atus_change ---+---+---+---+---+---+---+---+---+---+---+---+---...
# psql -p 9999 -U postgres -c "show pool_nodes;" node_id | hostname | port | status | pg_status | lb_weight | role | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change ---+---+---+---+---+--...
pgpool/pgpool2Public Notifications Fork82 Star289 Files master doc.ja doc m4 src auth config context include libs main parser pcp_con .gitignore README.add_pcp_command pcp_child.c pcp_worker.c recovery.c protocol query_cache redhat rewrite ...
(qr.active_role.unwrap(), Role::Primary); let q2 = simple_query("SET SERVER ROLE TO 'default'"); - assert!(qr.try_execute_command(&q2) != None); + assert!(qr.try_execute_command(&q2).is_some()); assert_eq!(qr.active_role.unwrap(), pool_settings.default_role); } @@ -...
(), default_role: String::from("any"), query_parser_enabled: false, query_parser_max_length: None, query_parser_read_write_splitting: false, primary_reads_enabled: false, - sharding_function: ShardingFunction::PgBigintHash, - automatic_sharding_key: None, connect_timeout: None, idle_time...