我做了apt-get install repmgr并尝试将repmgr从4.3升级到4.4
root@node-01:~# apt-get install repmgr
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
repmgr
0 upgraded, 1 newly installed, 0 to remove and 251 not upgraded.
Need t
我目前正在尝试安装Berkley Db。当我按照文档进行操作时,我遇到了以下错误。我在网上找不到关于这个问题的任何东西:
../src/repmgr/repmgr_net.c: In function '__repmgr_set_ssl_ctx':
../src/repmgr/repmgr_net.c:2897:6: error: 'repmgr_ssl_mutex_arr' undeclared (first use in this function); did you mean '__repmgr_ssl_readv'?
if (repm
上周末,我的测试环境出现了网络故障,最后我在集群中启动并运行了两个主数据库。
ID | Name | Role | Status | Upstream | Location | Priority | Connection string
----+-----------------------------------+---------+-----------+----------+----------+----------+--------------------------------------------------
我对postgres管理很陌生,我想知道"*“符号在repmgr cluster show命令输出中意味着什么。
ID | Name | Role | Status | Upstream | Location | Connection string
----+---------+---------+-----------+----------+----------+-------------------------------------------------------
我使用repmgr设置了Postgresql实例的副本,副本与主实例完全同步,并且从几天以来一直保持同步,但repmgr告诉我副本没有连接。这就是集群的样子:
postgres@www:~$ repmgr cluster show
ID | Name | Role | Status | Upstream | Location | Connection string
----+------------------+---------+-----------+-------------+---------+------------------------
因为备用服务器上没有可用的表空间,所以我的备用数据库被关闭了。
错误:
2021-06-01 15:16:30.061 EDT [21279] FATAL: directory "/data/xxx_data_tblsp" does not exist
2021-06-01 15:16:30.061 EDT [21279] HINT: Create this directory for the tablespace before restarting the server.
2021-06-01 15:16:30.061 EDT [21279] CONTEXT: WAL
我正在运行一个3节点的PostgreSQL 10 + repmgr 4.4集群:
1主节点 (postgres1.domain.local)
2稳定节点 (postgres2.domain.local和postgres2.domain.local)
在完全重新启动之前,集群运行良好。重新启动后,备用节点没有连接到主节点:
postgres@postgres1:/$ repmgr -f /etc/repmgr.conf cluster show
ID | Name | Role | Status | Upstream
我在测试repmgr工具,我有点困惑。在standby register步骤之前一切都很好。
我应该在standby服务器上配置什么?从docs中,我假设standby不应该拥有集群,但它没有配置新的集群。当postgres集群存在时,repmgr存在现有数据的问题。当我停止集群服务并手动删除数据并从repmgr运行迁移时,启动集群后会出现一个错误:
postgres@ip-10-0-34-147:~$ /usr/lib/postgresql/13/bin/pg_ctl -D /var/lib/postgresql/13/main start
waiting for server to sta
我是Postgresql和Pgpool安装程序的新手。我已经使用Pgpool和Repmgr配置了Postgresql /负载平衡。
The setup consist of 3 nodes and verison of Application and OS is as mentioned below:
**Pgpool node** => 192.168.0.4, **Postgresql Nodes** => 192.168.0.6, 192.168.0.7
**OS version** => CentOS 6.8 (On all the 3 nodes)
*