参见:
openGauss5.0单机版安装指南(企业版)_opengauss5.0安装指南-CSDN博客
记录在openEuler-22.03中安装openGauss_5.0.0企业版 - 墨天轮 (modb.pro)
注意:
gaussdb.xml不能有注释,nodename要和hostname对应
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
<CLUSTER>
<PARAM name="clusterName" value="gaussdb" />
<PARAM name="nodeNames" value="sartas" />
<PARAM name="gaussdbAppPath" value="/opt/huawei/install/app" />
<PARAM name="gaussdbLogPath" value="/var/log/omm" />
<PARAM name="tmpMppdbPath" value="/opt/huawei/tmp" />
<PARAM name="gaussdbToolPath" value="/opt/huawei/install/om" />
<PARAM name="corePath" value="/opt/huawei/corefile" />
<PARAM name="backIp1s" value="172.1.10.120"/>
</CLUSTER>
<DEVICELIST>
<DEVICE sn="node1_hostname">
<PARAM name="name" value="sartas"/>
<PARAM name="azName" value="AZ1"/>
<PARAM name="azPriority" value="1"/>
<PARAM name="backIp1" value="172.1.10.120"/>
<PARAM name="sshIp1" value="172.1.10.120"/>
<PARAM name="dataNum" value="1"/>
<PARAM name="dataPortBase" value="5432"/>
<PARAM name="dataNode1" value="/opt/huawei/install/data/dn"/>
<PARAM name="dataNode1_syncNum" value="0"/>
</DEVICE>
</DEVICELIST>
</ROOT>
pg_hba.conf文件:
(/opt/huawei/install/data/dn/)修改IPV4 local connections,新增md5
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 172.1.10.120/32 sha256
host all all 0.0.0.0/0 md5
postgresql.conf文件:
1、listen_addresses 改为*
listen_addresses = '*'
2、password_encryption_type=0
3、重启数据库
3、需要重新需改数据库密码