Mogdb 3.0 手动安装

1.环境说明

[omm@node1 bak]$ cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
[omm@node1 bak]$ lscpu
Architecture:          x86_64

2.检查环境

systemctl disable firewalld.service
systemctl stop firewalld.service
setenforce=0
sed -i '/^SELINUX=/c'SELINUX=disabled /etc/selinux/config

3.安装基础包

yum install -y libaio-devel 
yum install -y bzip2 libaio-devel flex bison ncurses-devel glibc-devel libxml2-devel patch redhat-lsb-core unzip gcc gcc-c++ perl openssl-devel libffi-devel libtool zlib-devel

4.创建相关目录，用户，组

groupadd dbgrp -g 2000
useradd omm -g 2000 -u 2000
echo "Enmotech2021@" | passwd --stdin omm
mkdir -p /opt/software/mogdb/
chown -R omm:dbgrp /opt/

5.上传上传并解压二进制文件

[root@node1 mogdb]# wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/MogDB-3.0.1-CentOS-x86_64.tar.gz
--2022-08-31 23:31:26--  https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/MogDB-3.0.1-CentOS-x86_64.tar.gz
正在解析主机 cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)... 124.236.20.228
正在连接 cdn-mogdb.enmotech.com (cdn-mogdb.enmotech.com)|124.236.20.228|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：139264406 (133M) [application/gzip]
正在保存至: “MogDB-3.0.1-CentOS-x86_64.tar.gz”

100%[============================================================================================================================================>] 139,264,406 13.0MB/s 用时 10s

2022-08-31 23:31:36 (12.8 MB/s) - 已保存 “MogDB-3.0.1-CentOS-x86_64.tar.gz” [139264406/139264406])

[root@node1 mogdb]# ll
总用量 136008
-rw-r--r-- 1 root root 139264406 8月   5 19:35 MogDB-3.0.1-CentOS-x86_64.tar.gz
[root@node1 mogdb]# tar -xf  MogDB-3.0.1-CentOS-x86_64.tar.gz
[root@node1 mogdb]# tar -xf MogDB-3.0.1-CentOS-64bit.tar.gz
[root@node1 mogdb]# ll
总用量 274052
drwxr-xr-x 3 root  root       4096 8月   5 17:54 bin
drwxr-xr-x 3 root  root       4096 8月   5 17:54 etc
drwxr-xr-x 3 root  root       4096 8月   5 17:54 include
drwxr-xr-x 4 root  root       4096 8月   5 17:54 jre
drwxr-xr-x 5 root  root       4096 8月   5 17:54 lib
-rw-r--r-- 1 20001 20001        65 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-cm.sha256
-rw-r--r-- 1 20001 20001   6411863 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-cm.tar.gz
-rw-r--r-- 1 20001 20001   5078313 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-Libpq.tar.gz
-rw-r--r-- 1 20001 20001        65 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-om.sha256
-rw-r--r-- 1 20001 20001  14167708 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-om.tar.gz
-rw-r--r-- 1 20001 20001        65 8月   5 18:38 MogDB-3.0.1-CentOS-64bit.sha256
-rw-r--r-- 1 20001 20001 107200316 8月   5 18:38 MogDB-3.0.1-CentOS-64bit.tar.gz
-rw-r--r-- 1 20001 20001   8028953 8月   5 18:38 MogDB-3.0.1-CentOS-64bit-tools.tar.gz
-rw-r--r-- 1 root  root  139264406 8月   5 19:35 MogDB-3.0.1-CentOS-x86_64.tar.gz
drwxr-xr-x 5 root  root       4096 8月   5 17:54 share
drwxr-xr-x 2 root  root       4096 8月   5 17:54 simpleInstall
-rw-r--r-- 1 20001 20001        65 8月   5 18:38 upgrade_sql.sha256
-rw-r--r-- 1 20001 20001    410121 8月   5 18:38 upgrade_sql.tar.gz
-rw-r--r-- 1 root  root         28 8月   5 17:54 version.cfg

6.配置环境变量

su - omm
echo "export GAUSSHOME=/opt/software/mogdb/"  >> /home/omm/.bashrc && \
echo "export PATH=\$GAUSSHOME/bin:\$PATH " >> /home/omm/.bashrc && \
echo "export LD_LIBRARY_PATH=\$GAUSSHOME/lib:\$LD_LIBRARY_PATH" >> /home/omm/.bashrc
source /home/omm/.bashrc

7.初始化数据库

[omm@node1 ~]$ gs_initdb --pgdata=/opt/mogdb/data --nodename=primary --pwpasswd=Enmo@123 --encoding=UTF-8 --locale=en_US.UTF-8
The files belonging to this database system will be owned by user "omm".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default text search configuration will be set to "english".

creating directory /opt/mogdb/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
.........
loading foreign-data wrapper for MOT access ... ok
loading security plugin ... ok
update system tables ... ok
creating snapshots catalog ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run gs_initdb.

Success. You can now start the database server of single node using:

    mogdb -D /opt/mogdb/data --single_node
or
    gs_ctl start -D /opt/mogdb/data -Z single_node -l logfile

8.修改初始化参数

echo "port=26000" >> /opt/mogdb/data/postgresql.conf
echo "listen_addresses = '0.0.0.0'" >> /opt/mogdb/data/postgresql.conf
echo "password_encryption_type = 1" >> /opt/mogdb/data/postgresql.conf
echo "log_directory = 'pg_log'" >> /opt/mogdb/data/postgresql.conf
echo "remote_read_mode=non_authentication" >> /opt/mogdb/data/postgresql.conf
echo "host all all 0.0.0.0/0 md5" >> /opt/mogdb/data/pg_hba.conf

9.启动数据库

[omm@node1 ~]$ gs_ctl start -D /opt/mogdb/data
[2022-08-31 23:35:19.920][13899][][gs_ctl]: gs_ctl started,datadir is /opt/mogdb/data
[2022-08-31 23:35:20.017][13899][][gs_ctl]: waiting for server to start...
.0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: node1

0 LOG:  [Alarm Module]Host IP: 172.24.11.219

0 LOG:  [Alarm Module]Cluster Name: dbCluster

0 WARNING:  failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING:  failed to parse feature control file: gaussdb.version.
0 WARNING:  Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
2022-08-31 23:35:20.239 [unknown] [unknown] localhost 140020818766080 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
.........
......
[2022-08-31 23:35:21.024][13899][][gs_ctl]:  done
[2022-08-31 23:35:21.024][13899][][gs_ctl]: server started (/opt/mogdb/data)

10.验证是否安装成功

[omm@node1 ~]$ gsql -d postgres -p26000 -r
gsql ((MogDB 3.0.1 build 1a363ea9) compiled at 2022-08-05 17:31:04 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
MogDB=# select version();
                                                                     version
--------------------------------------------------------------------------------------------------------------------------------------------------
 (MogDB 3.0.1 build 1a363ea9) compiled at 2022-08-05 17:31:04 commit 0 last mr   on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)