1、获取安装包
下载地址：https://opengauss.org/zh/download/
根据架构及系统下载对应安装包：例如openGauss-All-x.x.x-openEuler22.03-x86_64.tar.gz
推荐安装包(x86):openGauss-All-6.0.1-openEuler22.03-x86_64.tar.gz
新建存放安装包目录:mkdir -p /MedicomSoftware/openGauss
推荐下载:
cd /MedicomSoftware/openGauss
wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/6.0.1/openEuler22.03/x86/openGauss-All-6.0.1-openEuler22.03-x86_64.tar.gz
2、查看或修改hostname(名称不建议使用特殊字符)
#修改:
vim /etc/hostname
openeuler1
#查看:
cat /etc/hostname
#绑定hosts
vim /etc/hosts
127.0.0.1 openeuler1
3、准备软硬件安装环境
软件依赖安装:
yum update -y
yum install libaio-devel readline-devel expect -y
修改操作系统配置:
#关闭防火墙
systemctl stop firewalld.service
systemctl disable firewalld.service # 按需
systemctl status firewalld
#修改/etc/selinux/config文件中的“SELINUX”值为“disabled”
#a. 使用VIM打开config文件：
vim /etc/selinux/config
#b. 修改“SELINUX”的值“disabled”，执行:wq保存并退出修改
SELINUX=disabled
#修改 /etc/systemd/system.conf 文件
DefaultLimitNOFILE=1024:524288
#将1024改为 65535
#关闭RemoveIPC
#修改/etc/systemd/logind.conf文件中的“RemoveIPC”值为“no”
#a. 使用VIM打开logind.conf文件
vim /etc/systemd/logind.conf
#b. 修改“RemoveIPC”值为“no”
RemoveIPC=no
#修改/usr/lib/systemd/system/systemd-logind.service文件中的“RemoveIPC”值为“no”
#a. 使用VIM打开systemd-logind.service文件
vim /usr/lib/systemd/system/systemd-logind.service
#b. 修改“RemoveIPC”值为“no”
RemoveIPC=no
设置系统资源限制
#命令行输入如下设置
echo "* soft 1000000" >>/etc/security/limits.conf
echo "* hard nofile 1000000" >>/etc/security/limits.conf
echo "* hard nproc unlimited" >>/etc/security/limits.conf
echo "* soft nproc unlimited" >>/etc/security/limits.conf
重新加载配置参数(建议重启服务器)
systemctl daemon-reload
systemctl restart systemd-logind
4、初始化安装环境
解压缩安装包:
将安装包“openGauss-All-6.0.1-openEuler22.03-x86_64.tar.gz”和配置文件“cluster_config.xml”都上传至创建的目录“/MedicomSoftware/openGauss”中。
cd /MedicomSoftware/openGauss
tar -zxvf openGauss-All-6.0.1-openEuler22.03-x86_64.tar.gz
tar -zxvf openGauss-OM-6.0.1-openEuler22.03-x86_64.tar.gz
修改安装包目录权限:
chmod 755 -R /MedicomSoftware
使用gs_preinstall准备好安装环境:
#执行前置脚本准备好安装环境(root用户登录):
cd /MedicomSoftware/openGauss/script
./gs_preinstall -U omm -G dbgroup --one-stop-install
#接下来按提示交互输入相关信息，如安装路径：/MedicomSoftware/PIPPlatform/database_install/等
[root@openeuler1 script]# ./gs_preinstall -U omm -G dbgrp --one-stop-install --sep-env-file=ENVFILE
请选择是英文还是中文导航一键式生成xml文件?
>> 1) 中文
2) 英文
-------------------------------
请输入1/2进行选择,默认选项为1)中文:1
请输入xml的路径和文件名(默认:./cluster.xml):
请输入数据库安装目录(默认:/opt/openGauss/install):/MedicomSoftware/PIPPlatform/database_install
请输入数据库端口(默认:15000):5432
请选择是否主备部署?
>> 1) 主备部署
2) 单机部署
-------------------------------
请输入 1/2 进行选择，默认选项是 1)主备部署2
输入完成
生成的xml路径是: /script/base_utils/template/cluster.xml
xml内容是:
<ROOT>
<CLUSTER>
<PARAM name="clusterName" value="Cluster_template" />
<PARAM name="nodeNames" value="openeuler1" />
<PARAM name="gaussdbAppPath" value="/MedicomSoftware/PIPPlatform/database_install/app" />
<PARAM name="gaussdbLogPath" value="/MedicomSoftware/PIPPlatform/database_install/log" />
<PARAM name="tmpMppdbPath" value="/MedicomSoftware/PIPPlatform/database_install/mp" />
<PARAM name="gaussdbToolPath" value="/MedicomSoftware/PIPPlatform/database_install/tool" />
<PARAM name="corePath" value="/MedicomSoftware/PIPPlatform/database_install/corefile" />
<PARAM name="backIp1s" value="172.20.2.121" />
</CLUSTER>
<DEVICELIST>
<DEVICE sn="node1_hostname">
<PARAM name="name" value="openeuler1" />
<PARAM name="azName" value="AZ1" />
<PARAM name="azPriority" value="1" />
<PARAM name="backIp1" value="172.20.2.121" />
<PARAM name="sshIp1" value="172.20.2.121" />
<PARAM name="dataNum" value="1" />
<PARAM name="dataPortBase" value="5432" />
<PARAM name="dataNode1" value="/MedicomSoftware/PIPPlatform/database_install/data/dn" />
<PARAM name="dataNode1_syncNum" value="0" />
</DEVICE>
</DEVICELIST>
</ROOT>
请确认xml的内容是否正确,正确输入yes;如需修改xml内容请自行修改,然后输入yes确认yes
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Setting host ip env
Successfully set host ip env.
Are you sure you want to create the user[omm] (yes/no)? yes
[GAUSS-50305] : The user is not matched with the user group.
5、执行安装
登录到omm用户执行安装
su - omm
cd /MedicomSoftware/openGauss/script
./gs_install -X ./base_utils/template/cluster.xml
#示例说明:
交互输入提示“Please enter password for database:” 输入数据库管理员用户密码:@Medic0m
删除默认初始化文件
su - omm
gs_om -t restart
gs_om -t stop
gs_om -t status --detail
rm -rf /MedicomSoftware/PIPPlatform/database_install/data/dn
重新初始化为PG模式
su - omm
cd /MedicomSoftware/PIPPlatform/database_install/app/bin
./gs_initdb -D /MedicomSoftware/PIPPlatform/database_install/data/dn --nodename=openeuler1 --dbcompatibility=PG
6、修改postgresql.conf和pg_hba.conf配置文件
su - omm
gs_om -t stop
gs_om -t status --detail
a. 使用VIM打开postgresql.conf文件
vim /MedicomSoftware/PIPPlatform/database_install/data/dn/postgresql.conf
#参照修改postgresql.conf文件中的如下参数
listen_addresses = '*'
local_bind_address = '0.0.0.0' ###IP修改成实际IP地址
port = 5432
max_connections = 2000
password_encryption_type = 1
krb_caseins_users = on
shared_buffers = 16GB ###根据服务器内存适当调整
cstore_buffers = 512MB
#max_concurrent_autonomous_transactions = 0
b. 使用VIM打开pg_hba.conf文件
vim /MedicomSoftware/PIPPlatform/database_install/data/dn/pg_hba.conf
#参照修改或添加pg_hba.conf文件中的如下参数
# IPv4 local connections:
host all all 0.0.0.0/0 md5
c. 重启服务
su - omm
gs_om -t restart
gs_om -t status --detail
7、创建管理员用户
gsql -d postgres
设置omm密码:
openGauss=# ALTER ROLE "omm" PASSWORD '@Medic0m';
设置不限制密码复用次数:
openGauss=# ALTER SYSTEM SET password_reuse_max = 0;
openGauss=# SHOW password_reuse_max;
设置不限制密码复用天数
openGauss=# ALTER SYSTEM SET password_reuse_time = 0;
openGauss=# SHOW password_reuse_time;
创建medicom管理员用户:
openGauss=# CREATE USER medicom WITH SYSADMIN password "@Medic0m";
创建数据库:
openGauss=# create database "MedicomPIP2DB" OWNER medicom;
查询数据库兼容模式:
openGauss=# SHOW sql_compatibility;
查询数据库版本:
openGauss=# select version();
退出数据库:
openGauss=# \q
8、设置开机启动服务(参考)
su - omm
gs_om -t stop
gs_om -t status --detail
su - root
添加pip-database服务(root用户登录)：
#pip-database.service文件添加内容
vim /etc/systemd/system/pip-database.service
[Unit]
Description=pip-database
Documentation=pip-database Server
After=syslog.target
After=network.target
[Service]
Type=forking
User=omm
Group=dbgroup
Environment=GPHOME=/MedicomSoftware/PIPPlatform/database_install/tool
Environment=PGDATA=/MedicomSoftware/PIPPlatform/database_install/data/dn
Environment=GAUSSHOME=/MedicomSoftware/PIPPlatform/database_install/app
Environment=LD_LIBRARY_PATH=/MedicomSoftware/PIPPlatform/database_install/app/lib
ExecStart=/MedicomSoftware/PIPPlatform/database_install/tool/script/gs_om -t start
ExecStop=/MedicomSoftware/PIPPlatform/database_install/tool/script/gs_om -t stop
ExecRestart=/MedicomSoftware/PIPPlatform/database_install/tool/script/gs_om -t restart
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=0
[Install]
WantedBy=multi-user.target
赋予服务执行权限并设置开机自启
chmod u+x /etc/systemd/system/pip-database.service
systemctl daemon-reload
systemctl enable pip-database
systemctl restart pip-database
systemctl status pip-database
9、还原数据库
还原数据库
su root
chown omm:dbgroup /Medicomsoftware/PIP2_202506Beta2_linux/pip_platform_install/product/extra_database/openGaussbak/openGauss6_pip_2506_20250820_1700.dump
su - omm
gs_restore -d MedicomPIP2DB -U medicom /Medicomsoftware/PIP2_202506Beta2_linux/pip_platform_install/product/extra_database/openGaussbak/openGauss6_pip_2506_20250820_1700.dump
评论
评论列表