openEuler安装openGauss5.0单机数据库

1、操作系统配置

说明：本次测试中，同时安装了两个版本的openEuler操作系统，分别是openEuler23.09和openEuler22.03。操作系统下载地址如下：
https://www.openeuler.org/en/download

[gauss@openGauss:/home/gauss]$cat /etc/os-release
NAME="openEuler"
VERSION="23.09"
ID="openEuler"
VERSION_ID="23.09"
PRETTY_NAME="openEuler 23.09"
ANSI_COLOR="0;31"

1.1、配置/etc/hosts

vi /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.80.223 openGauss

1.2、关闭防火墙

-- 设置 /etc/selinux/config
echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
cat /etc/selinux/config

-- 停止及关闭防火墙
systemctl stop firewalld.service

systemctl disable firewalld.service

1.3、配置/etc/security/limits.conf和/etc/sysctl.conf

cat >> /etc/security/limits.conf  << EOF
*       soft    nproc   65535 
*       hard    nproc   65535
*       soft    nofile  65535
*       hard    nofile  65535
*       soft   stack    65535
*       hard   stack    65535
*       hard memlock unlimited
*       soft memlock unlimited
EOF

cat  /etc/security/limits.conf

echo "vm.swappiness=1" >> /etc/sysctl.conf
echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "net.ipv4.tcp_retries1=5" >> /etc/sysctl.conf
echo "net.ipv4.tcp_syn_retries=5" >> /etc/sysctl.conf
echo "net.ipv4.tcp_synack_retries=5" >> /etc/sysctl.conf
echo "net.ipv4.tcp_retries2=12" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range=26000 65535" >> /etc/sysctl.conf
echo "vm.min_free_kbytes=512000" >> /etc/sysctl.conf
echo "net.ipv4.tcp_fin_timeout=60" >> /etc/sysctl.conf
echo "net.ipv4.tcp_sack=1" >> /etc/sysctl.conf
echo "net.ipv4.tcp_timestamps=1" >> /etc/sysctl.conf
echo "vm.extfrag_threshold=500" >> /etc/sysctl.conf
echo "vm.overcommit_ratio=90" >> /etc/sysctl.conf

sysctl -p

1.5、挂载光驱及安装依赖包

-- 挂载光驱
mount /dev/cdrom /mnt

cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/

vi /etc/yum.repos.d/yum.local.repo 

[local]
name=yum local repo
baseurl=file:///mnt
gpgcheck=0
enable=1

-- 安装依赖包
yum install -y libaio-devel libnsl flex bison ncurses-devel glibc-devel patch readline-devel
 
yum install -y net-tools tar bzip2 python3 cmake make gcc zlib gcc-c++ perl  zlib-devel tcl openssl openldap pam

1.6、创建gauss用户及目录

mkdir /gauss

mkdir -p /gauss/{
   gaussdb,archive,scripts,backup,soft}

groupadd gauss
useradd -g gauss -d /home/gauss -m -s /bin/bash gauss

-- 设置gauss用户密码
echo "gauss" |passwd --stdin gauss

chown -R gauss:gauss /gauss

2、安装openGauss数据库

2.1、下载数据库软件及上传并解压

https://opengauss.org/zh/download/

上传到 /gauss/soft 目录

[gauss@openGauss:/home/gauss]$cd /gauss/soft
[gauss@openGauss:/gauss/soft]$tar zxvf openGauss-5.0.0-CentOS-64bit-all.tar.gz
openGauss-5.0.0-CentOS-64bit-cm.tar.gz
openGauss-5.0.0-CentOS-64bit-om.tar.gz
openGauss-5.0.0-CentOS-64bit.tar.bz2
openGauss-5.0.0-CentOS-64bit-cm.sha256
openGauss-5.0.0-CentOS-64bit-om.sha256
openGauss-5.0.0-CentOS-64bit.sha256
upgrade_sql.tar.gz
upgrade_sql.sha256
[gauss@openGauss:/gauss/soft]$tar jxvf openGauss-5.0.0-CentOS-64bit.tar.bz2 -C /gauss/gaussdb/

2.2、配置环境变量

su - gauss

vi ~/.bash_profile

export LANG=en_US.UTF8
export PS1="[`whoami`@`hostname`:"'$PWD]$'
export GAUSSHOME=/gauss/gaussdb
export LD_LIBRARY_PATH=/gauss/gaussdb/lib
export PATH=/gauss/gaussdb/bin:$PATH:$HOME/.local/bin:$HOME/bin

编辑 .bashrc 注释 ulimit -n 1000000

[gauss@openGauss:/gauss/soft]$cd 
[gauss@openGauss:/gauss/soft]$ls<