文章目录
- 环境
- 症状
- 问题原因
- 解决方案
环境
系统平台：N/A
版本：6.0
症状
安装oracle_fdw插件报could not load library “/opt/HighGo6.0.4-cluster/lib/postgresql/oracle_fdw.so”: libnnz19.so: cannot open shared object file: No such file or directory 检查
ldd /opt/HighGo6.0.4-cluster/lib/postgresql/oracle_fdw.so|grep libnnz19.so问题原因
因为HGHAC服务中未设置环境变量LD_LIBRARY_PATH。
解决方案
1、编辑环境变量配置文件(每个数据库节点）
[root@hac1 ~]# vi /home/highgo/highgo.env LD_LIBRARY_PATH=/opt/HighGo6.0.4-cluster/lib:LD_LIBRARY_PATH2、HGHAC启动文件添加(每个数据库节点）
[root@hac1 ~]# vi /usr/lib/systemd/system/hghac [Unit] Description=hghac After=syslog.target network.target [Service] Type=simple User=highgo Group=highgo EnvironmentFile=/home/highgo/highgo.env ---添加这一行 # Start the hghac process ExecStart=/usr/local/hghac/hac/hghac/hghac /usr/local/hghac/hac/hghac.yml # Send HUP to reload from hghac.yml ExecReload=/bin/kill -s HUP $MAINPID Restart=on-failure KillMode=process [Install] WantedBy=multi-user.target highgo.env3、载入HGHAC(每个数据库节点）
[root@hac1 ~]# systemctl daemon-reload4、关闭HGHAC，启动HGHAC
查看主备节点
[root@hac1 ~]# hghact list + Cluster: hgdbcluster -----------+--------------+-----------+----+-----------+ | Member | Host | Role | State | TL | Lag in MB | +------------+--------------------+--------------+-----------+----+-----------+ | hghac56.10 | x.x.56.10:5866 | Leader | running | 11 | | | hghac56.11 | x.x.56.11:5866 | Sync Standby | streaming | 11 | 0 | | hghac56.12 | x.x.56.12:5866 | Replica | streaming | 11 | 0 | +------------+--------------------+--------------+-----------+----+-----------+ 先关闭备节点，再关闭主节点 ---------关闭命令 [root@hac1 ~]# systemctl stop hghac关闭后先启动主节点，再启动备节点
---------启动命令 [root@hac1 ~]# systemctl start hghac5、进入数据库，创建oracle_fdw
[root@hac1 ~]# psql -U highgo highgo=# create extension oracle_fdw; CREATE EXTENSION
