1.環(huán)境說明
[omm@node1 bak]$ cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
[omm@node1 bak]$ lscpu
Architecture: x86_64
2.檢查環(huán)境
systemctl disable firewalld.service
systemctl stop firewalld.service
setenforce=0
sed -i '/^SELINUX=/c'SELINUX=disabled /etc/selinux/config
3.安裝基礎(chǔ)包
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.創(chuàng)建相關(guān)目錄,用戶,組
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.上傳上傳并解壓二進(jìn)制文件
[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
正在解析主機(jī) 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... 已連接。
已發(fā)出 HTTP 請求,正在等待回應(yīng)... 200 OK
長度:139264406 (133M) [application/gzip]
正在保存至: “MogDB-3.0.1-CentOS-x86_64.tar.gz”
100%[============================================================================================================================================>] 139,264,406 13.0MB/s 用時(shí) 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.配置環(huán)境變量
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.初始化數(shù)據(jù)庫
[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.修改初始化參數(shù)
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.啟動數(shù)據(jù)庫
[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.驗(yàn)證是否安裝成功
[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)
最后修改時(shí)間:2022-09-01 08:47:32
「喜歡這篇文章,您的關(guān)注和贊賞是給作者最好的鼓勵(lì)」
關(guān)注作者
【版權(quán)聲明】本文為墨天輪用戶原創(chuàng)內(nèi)容,轉(zhuǎn)載時(shí)必須標(biāo)注文章的來源(墨天輪),文章鏈接,文章作者等基本信息,否則作者和墨天輪有權(quán)追究責(zé)任。如果您發(fā)現(xiàn)墨天輪中有涉嫌抄襲或者侵權(quán)的內(nèi)容,歡迎發(fā)送郵件至:contact@modb.pro進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),墨天輪將立刻刪除相關(guān)內(nèi)容。




