【我和openGauss的故事】编译安装openGauss 5.0.0

openGauss支持的操作系统：

CentOS 7.6（x86 架构）
openEuler-20.03-LTS（aarch64 架构）
openEuler-20.03-LTS（x86 架构）
Kylin-V10（aarch64 架构）
1.
2.
3.
4.
5.
6.

[root@og3 ~]# cat /etc/redhat-release 
CentOS Linux release 7.6.1810 (Core)
1.
2.

hostnamectl set-hostname og
cat>>/etc/hosts<<EOF
192.168.137.129    og
EOF
1.
2.
3.
4.

systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
systemctl is-enabled firewalld
/bin/sed -i s/SELINUX=enforcing/SELINUX=disabled/ /etc/selinux/config
cat /etc/selinux/config|grep SELINUX=
setenforce 0
1.
2.
3.
4.
5.
6.
7.

[root@og3 ~]# mkdir -p /soft
[root@og3 ~]# cd /soft
[root@og3 soft]# ls -ltr
total 4481024
-rw-r--r--. 1 root root 4588568576 Apr  8  2019 CentOS-7-x86_64-DVD-1810.iso
1.
2.
3.
4.
5.

cd /soft
mv CentOS-7-x86_64-DVD-1810.iso yum.iso
mount -o loop /soft/yum.iso /mnt
mkdir -p /etc/yum.repos.d/bak/
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak/
cat>>/etc/yum.repos.d/rhel-source.repo <<EOF
[rhel-oracle-lib]
name=oracle
baseurl=file:///mnt
enabled=1
gpgcheck=0
EOF
yum clean all
yum makecache
yum list

yum -y install libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb readline-devel unzip dos2unix vim git wget lrzsz net-tools bzip2 gcc tree zlib*
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

cat>>/etc/profile<<EOF
export LANG=zh_CN.UTF-8
EOF
1.
2.
3.

[root@og ~]# timedatectl set-timezone Asia/Shanghai
[root@og ~]# timedatectl status

使用date -s命令将各主机的时间设置为统一时间，举例如下。

date -s "Sat Sep 27 16:00:07 CST 2020"
1.
2.
3.
4.
5.
6.

cat>>/etc/profile<<EOF
HISTSIZE=0
EOF
1.
2.
3.

cd /soft/
wget -c https://www.python.org/ftp/python/3.6.5/Python-3.6.5.tgz
mkdir -p /usr/local/python3.6.5
tar -zxvf Python-3.6.5.tgz
cd Python-3.6.5
./configure --prefix=/usr/local/python3.6.5 --enable-shared CFLAGS=-fPIC && make && make install
rm -f /usr/bin/python
ln -s /usr/local/python3.6.5/bin/python3 /usr/bin/python
ln -s /usr/local/python3.6.5/bin/python3 /usr/bin/python3
ln -s /usr/local/python3.6.5/bin/pip3 /usr/bin/pip3

cp /usr/local/python3.6.5/lib/libpython3.6m.so.1.0 /usr/lib64/
python -V
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.

cd /soft/
git clone https://gitee.com/opengauss/openGauss-server.git openGauss-server -b 5.0.0
git clone https://gitee.com/opengauss/openGauss-OM.git -b 5.0.0
wget -c https://opengauss.obs.cn-south-1.myhuaweicloud.com/5.0.0/binarylibs/openGauss-third_party_binarylibs_Centos7.6_x86_64.tar.gz
1.
2.
3.
4.

tar -xf openGauss-third_party_binarylibs_Centos7.6_x86_64.tar.gz
mv openGauss-third_party_binarylibs_Centos7.6_x86_64 binarylibs
cd openGauss-server/
sh build.sh -m debug -3rd /soft/binarylibs -pkg
1.
2.
3.
4.

success!

生成的安装包会存放在./output目录下。
编译和打包日志为：./build/script/makemppdb_pkg.log。
1.
2.
3.
4.

cd /soft/openGauss-OM
chmod +x build.sh
export BINARYLIBS_PATH=/soft/binarylibs  (这里填写前面的第三方软件包解压后的目录)
./build.sh -3rd $BINARYLIBS_PATH
1.
2.
3.
4.

ROOT_DIR: /soft/binarylibs
Everything is ready.
success!
1.
2.
3.

mkdir -p /opt/software/openGauss
mv /soft/openGauss-server/output/* /opt/software/openGauss/
mv /soft/openGauss-OM/package/* /opt/software/openGauss/
chmod 755 -R /opt/software
cd /opt/software/openGauss/

tar -jxf openGauss-5.0.0-CentOS-64bit.tar.bz2
tar -xf openGauss-5.0.0-CentOS-64bit-om.tar.gz
1.
2.
3.
4.
5.
6.
7.
8.

groupadd dbgrp
useradd omm -g dbgrp
echo "Root_1234"|passwd --stdin omm
1.
2.
3.

cat >> /opt/software/openGauss/cluster_config.xml <<-EOF
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
    <!-- openGauss整体信息 -->
    <CLUSTER>
        <!-- 数据库名称 -->
        <PARAM name="clusterName" value="dbCluster" />
        <!-- 数据库节点名称(hostname) -->
        <PARAM name="nodeNames" value="`hostname`" />
        <!-- 数据库安装目录-->
        <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" />
        <!-- 数据库core文件目录-->
        <PARAM name="corePath" value="/opt/huawei/corefile" />
        <!-- 节点IP，与数据库节点名称列表一一对应 -->
        <PARAM name="backIp1s" value="`cat /etc/hosts|grep \`hostname\`|awk '{print $1}'|head -1`"/> 
    </CLUSTER>
    <!-- 每台服务器上的节点部署信息 -->
    <DEVICELIST>
        <!-- 节点1上的部署信息 -->
        <DEVICE sn="node1_hostname">
            <!-- 节点1的主机名称 -->
            <PARAM name="name" value="`hostname`"/>
            <!-- 节点1所在的AZ及AZ优先级 -->
            <PARAM name="azName" value="AZ1"/>
            <PARAM name="azPriority" value="1"/>
            <!-- 节点1的IP，如果服务器只有一个网卡可用，将backIP1和sshIP1配置成同一个IP -->
            <PARAM name="backIp1" value="`cat /etc/hosts|grep \`hostname\`|awk '{print $1}'|head -1`"/>
            <PARAM name="sshIp1" value="`cat /etc/hosts|grep \`hostname\`|awk '{print $1}'|head -1`"/>
               
	    <!--dbnode-->
	    <PARAM name="dataNum" value="1"/>
	    <PARAM name="dataPortBase" value="15400"/>
	    <PARAM name="dataNode1" value="/opt/huawei/install/data/dn"/>
            <PARAM name="dataNode1_syncNum" value="0"/>
        </DEVICE>
    </DEVICELIST>
</ROOT>
EOF
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.

/opt/software/openGauss/script/gs_preinstall -U omm -G dbgrp -L -X /opt/software/openGauss/cluster_config.xml
1.

su - omm
gs_install -X /opt/software/openGauss/cluster_config.xml
1.
2.

[root@og openGauss]# su - omm                                                                             
Last login: Mon May  9 19:28:07 CST 2022 on pts/1

[omm@og ~]$ gs_om -t status


执行如下命令检查数据库状态是否正常，“cluster_state ”显示“Normal”表示数据库可正常使用。


[omm@og ~]$ gsql -p 15400 -d postgres
gsql ((openGauss 5.0.0 build 2e619658) compiled at 2023-07-14 01:21:30 commit 0 last mr  debug)
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=# \l
                          List of databases
   Name    | Owner | Encoding  | Collate | Ctype | Access privileges
-----------+-------+-----------+---------+-------+-------------------
 postgres  | omm   | SQL_ASCII | C       | C     |
 template0 | omm   | SQL_ASCII | C       | C     | =c/omm           +
           |       |           |         |       | omm=CTc/omm
 template1 | omm   | SQL_ASCII | C       | C     | =c/omm           +
           |       |           |         |       | omm=CTc/omm
(3 rows)

openGauss=#
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.

cd /soft/openGauss-server
1.

export CODE_BASE=/soft/openGauss-server    # openGauss-server的路径
export BINARYLIBS=/soft/binarylibs    # binarylibs的路径
export GAUSSHOME=$CODE_BASE/dest/
export GCC_PATH=$BINARYLIBS/buildtools/gcc7.3/
export CC=$GCC_PATH/gcc/bin/gcc
export CXX=$GCC_PATH/gcc/bin/g++
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$GCC_PATH/gcc/lib64:$GCC_PATH/isl/lib:$GCC_PATH/mpc/lib/:$GCC_PATH/mpfr/lib/:$GCC_PATH/gmp/lib/:$LD_LIBRARY_PATH
export PATH=$GAUSSHOME/bin:$GCC_PATH/gcc/bin:$PATH
1.
2.
3.
4.
5.
6.
7.
8.

./configure --gcc-version=7.3.0 CC=g++ CFLAGS='-O0' --prefix=$GAUSSHOME --3rd=$BINARYLIBS --enable-debug --enable-cassert --enable-thread-safety --with-readline --without-zlib
1.

make && make install

note:
openGauss InstallationGuide complete.
1, 编译后软件安装路径为：$GAUSSHOME
2. 编译后的二进制放置路径为：$GAUSSHOME/bin
1.
2.
3.
4.
5.
6.

### 1. 使用root用户，创建用户omm
groupadd dbgrp
useradd omm -g dbgrp
echo "Root_1234"|passwd --stdin omm

### 2. 使用omm用户，在~/.bashrc中增加以下环境变量
cat>>/home/omm/.bashrc<<EOF
export GAUSSHOME=/soft/openGauss-server/dest/ ##编译结果的路径，可根据实际情况修改
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export PATH=$GAUSSHOME/bin:$PATH
EOF

### 3. 建立数据目录和日志目录
su - omm -c "mkdir ~/data"
su - omm -c "mkdir ~/log"
chown -R omm:dbgrp /soft/openGauss-server

### 4. 数据库初始化
su - omm
gs_initdb -D /home/omm/data --nodename=db1 

### 5. 启动数据库
gs_ctl start -D /home/omm/data -Z single_node -l /home/omm/log/opengauss.log

[omm@og ~]$ gsql -d postgres

ALTER ROLE "omm" PASSWORD 'Root_1234';
openGauss=# \l
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.

https://docs.opengauss.org/zh/docs/5.0.0/docs/CompilationGuide/%E7%89%88%E6%9C%AC%E7%BC%96%E8%AF%91.html
1.