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
#关闭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/等
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
评论
评论列表