【我和openGauss的故事】体验openGauss 5.0.0 单机极简版安装指南

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

https://docs.opengauss.org/zh/docs/5.0.0/docs/InstallationGuide/%E6%9E%81%E7%AE%80%E7%89%
1.

vim /etc/selinux/config
1.

SELINUX=disabled
1.

systemctl status firewalld
1.

systemctl disable firewalld.service
systemctl stop firewalld.service
1.
2.

[root@master1 data]# su omm
[omm@master1 data]$ sudo mkdir openGauss
[omm@master1 data]$ tar -jxf openGauss-5.0.0-CentOS-64bit.tar.bz2 -C /opt/software/openGauss/
[omm@master1 data]$
1.
2.
3.
4.

[omm@master1 openGauss]$ ls -lb
total 32
drwxr-xr-x 2 omm omm 4096 Mar 29 03:20 bin
drwxr-xr-x 3 omm omm 4096 Mar 29 03:20 etc
drwxr-xr-x 3 omm omm 4096 Mar 29 03:20 include
drwxr-xr-x 4 omm omm 4096 Mar 29 03:20 jre
drwxr-xr-x 5 omm omm 4096 Mar 29 03:20 lib
drwxr-xr-x 5 omm omm 4096 Mar 29 03:20 share
drwxr-xr-x 2 omm omm 4096 Mar 29 03:20 simpleInstall
-rw-r--r-- 1 omm omm   32 Mar 29 03:20 version.cfg
[omm@master1 openGauss]$
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.

[omm@master1 openGauss]$ cd simpleInstall/
[omm@master1 simpleInstall]$ ls
finance.sql  install.sh  README.md  school.sql
[omm@master1 simpleInstall]$
1.
2.
3.
4.

[omm@master1 simpleInstall]$ sh install.sh  -w "Kunpeng@0715" &&source ~/.bashrc
[step 1]: check parameter
[step 2]: check install env and os setting
[step 3]: change_gausshome_owner
[step 4]: set environment variables

/home/omm/.bashrc: line 16: ulimit: open files: cannot modify limit: Operation not permitted
[step 6]: init datanode
The files belonging to this database system will be owned by user "omm".
This user must also own the server process.

直到出现
Would you like to create a demo database (yes/no)? yes
Load demoDB [school,finance] success.
[complete successfully]: You can start or stop the database server using:
    gs_ctl start|stop|restart -D $GAUSSHOME/data/single_node -Z single_node
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

[omm@master1 simpleInstall]$ ps ux | grep gaussdb
omm       53194  2.8  2.5 6201936 832576 ?      Ssl  22:28   0:05 /opt/software/openGauss/bin/gaussdb -D /opt/software/openGauss/data/single_node
omm       54114  0.0  0.0 110480   908 pts/0    S+   22:31   0:00 grep --color=auto gaussdb
1.
2.
3.

[omm@master1 simpleInstall]$ gs_ctl query -D /opt/software/openGauss/data/single_node
[2023-07-18 22:31:59.874][54137][][gs_ctl]: gs_ctl query ,datadir is /opt/software/openGauss/data/single_node 
 HA state:           
	local_role                     : Normal
	static_connections             : 0
	db_state                       : Normal
	detail_information             : Normal

 Senders info:       
No information 
 Receiver info:      
No information 
[omm@master1 simpleInstall]$
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.

[omm@master1 ~]$ gs_ctl notify
[2023-07-19 09:11:20.012][92324][][gs_ctl]: gs_ctl notify ,datadir is /opt/software/openGauss/data 
[2023-07-19 09:11:20.012][92324][][gs_ctl]: the parameter of notify must be specified
[omm@master1 ~]$
1.
2.
3.
4.

[omm@master1 ~]$ vim .bashrc

# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# Uncomment the following line if you don't like systemctl's auto-paging feature:
# export SYSTEMD_PAGER=

# User specific aliases and functions
export GAUSSHOME=/opt/software/openGauss
export PATH=$GAUSSHOME/bin:$PATH
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export GS_CLUSTER_NAME=dbCluster
export PGDATA=/opt/software/openGauss/data
ulimit -n 1000000
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.

[omm@master1 ~]$ grep -i PGDATA ~/.bashrc
export PGDATA=/opt/software/openGauss/data
[omm@master1 ~]$
1.
2.
3.

[omm@master1 ~]$ gsql -d postgres
gsql ((openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=#
1.
2.
3.
4.
5.
6.

[root@master1 data]# groupadd dbgroup
[root@master1 data]#
1.
2.

[root@master1 data]# useradd -g dbgroup omm
[root@master1 data]# passwd omm
Changing password for user omm.
New password: 
BAD PASSWORD: The password contains the user name in some form
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@master1 data]#
1.
2.
3.
4.
5.
6.
7.
8.

[root@master1 simpleInstall]# sh install.sh  -w "Kunpeng@0715" &&source ~/.bashrc
[step 1]: check parameter
Error: can not install openGauss with root
1.
2.
3.

[root@master1 data]# su omm
1.

[omm@master1 openGauss]$ cd simpleInstall/
bash: cd: simpleInstall/: Permission denied
1.
2.

[root@master1 data]# chown -R omm.omm openGauss
[root@master1 data]# 
[root@master1 data]# su omm
[omm@master1 data]$ cd openGauss/
[omm@master1 openGauss]$ ls
bin  etc  include  jre  lib  share  simpleInstall  version.cfg
[omm@master1 openGauss]$ cd simpleInstall/
[omm@master1 simpleInstall]$ ls
finance.sql  install.sh  README.md  school.sql
[omm@master1 simpleInstall]$
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

[omm@master1 simpleInstall]$ sh install.sh  -w "Kunpeng@0715" &&source ~/.bashrc
[step 1]: check parameter
[step 2]: check install env and os setting
On systemwide basis, the maximum number of SEMMNI is not correct. the current SEMMNI value is: 128. Please check it.
The required value should be greater than 321. You can modify it in file '/etc/sysctl.conf'.
[omm@master1 simpleInstall]$
1.
2.
3.
4.
5.
6.

[omm@master1 simpleInstall]$ sudo sysctl -w kernel.sem="250 85000 250 330" 
[sudo] password for omm: 
kernel.sem = 250 85000 250 330
[omm@master1 simpleInstall]$
1.
2.
3.
4.

[omm@master1 simpleInstall]$ gs_ctl status
[2023-07-19 09:04:51.833][90515][][gs_ctl]:  no database directory specified and environment variable PGDATA unset
Try "gs_ctl --help" for more information.
[omm@master1 simpleInstall]$
1.
2.
3.
4.

[omm@master1 data]$ cd ~
[omm@master1 ~]$ vi ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

export PGDATA=/opt/software/openGauss/data
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

[omm@master1 ~]$ . ~/.bash_profile
1.

[omm@master1 ~]$ gs_ctl status
[2023-07-19 09:08:42.706][91569][][gs_ctl]: gs_ctl status,datadir is /opt/software/openGauss/data 
no server running
[omm@master1 ~]$
1.
2.
3.
4.