OK. I was finally able to fix this. The problem was in The issue can be fixed with making pgpool user part of "pg_monitor` 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_...
Following a primary PG pod restart (i.e. because of a K8s node is drained), and this is triggering the standby to take the role of primary, then the client application is apparently still getting connected to the now read-only instance and create/update/delete SQL statements are failing. ...
postgres=# 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 ---+---+---+---+---+---+---+---+---+---+...
Name and Version bitnami/postgresql-repmgr:14.4.0-debian-11-r3 What steps will reproduce the bug? Name and Version bitnami/postgresql-repmgr:14.4.0-debian-11-r3 What steps will reproduce the bug? we have set up microk8s(on Ubuntu servers...
在关闭server1上的PG后,failover自动发生,节点3成为新的主库: 代码语言:javascript 复制 [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 | select_cnt | load_bala...
在关闭server1上的PG后,failover自动发生,节点3成为新的主库: 代码语言:javascript 复制 [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 | select_cnt | load_bala...
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 ...
当您安装 pgpool-II 后, pgpool.conf.sample 被自动建立。我们建议拷贝或者重命名它为 pgpool.conf ,然后您可以随意编辑它。 $ cp /usr/local/etc/pgpool.conf.sample /usr/local/etc/pgpool.conf pgpool-II 默认只接受到 9999 端口的本地连接。如果您希望从其他主机接受连接,请设置 ...