Centos7.6安装openGauss 6.0.0 (LTS)

环境信息：架构：x86_64操作系统：Centos7.6数据库：openGauss 6.0.0 (LTS)

yum install readline -yyum install libaio-devel -yyum install bc -yyum install net-tools -yyum install sysstat -yyum install -y ntp ntpdate

关闭防火墙并禁止开机启动systemctl stop firewalldsystemctl disable firewalld
检查防火墙是否启动systemctl status firewalld

查看selinux状态getenforce
关闭selinux并禁止开机启动vim /etc/sysconfig/selinuxSELINUX=disabled

修改sshd配置并重启vim /etc/ssh/sshd_configPermitRootLogin yes
systemctl restart sshd

# 避免文件在用户登录创建后登出被变化的情况关闭RemoveIPC echo "RemoveIPC = no" >> /usr/lib/systemd/system/systemd-logind.servicesed -i 's/.*RemoveIPC.*/RemoveIPC=no/' /etc/systemd/logind.conf 
systemctl daemon-reloadsystemctl restart systemd-logind
#检查修改是否生效loginctl show-session | grep RemoveIPCsystemctl show systemd-logind | grep RemoveIPC*结果都为RemoveIPC=no   

vim /etc/security/limits.conf* soft nproc unlimited* hard nproc unlimited* soft nofile 65535* hard nofile 65535* soft stack unlimited* hard stack unlimited* soft core unlimited* hard core unlimited* soft memlock unlimited* hard memlock unlimited

echo $LANGen_US.utf8
vim /etc/profileexport LANG=en_US.utf8

查看有en_US.utf8locale -a |grep -i en_USen_USen_US.iso88591en_US.iso885915en_US.utf8
如果没有，添加localedef -v -c -i en_US -f UTF-8 en_US.UTF-8

[root@VM-12-13-centos soft]# lltotal 149764-rw-r--r-- 1 root root 153356080 Sep 29 22:18 openGauss-All-6.0.0-CentOS7-x86_64.tar.gz[root@VM-12-13-centos soft]# pwd/root/soft
[root@VM-12-13-centos soft]# tar -zxvf openGauss-All-6.0.0-CentOS7-x86_64.tar.gzopenGauss-CM-6.0.0-CentOS7-x86_64.tar.gzopenGauss-OM-6.0.0-CentOS7-x86_64.tar.gzopenGauss-Server-6.0.0-CentOS7-x86_64.tar.bz2openGauss-CM-6.0.0-CentOS7-x86_64.sha256openGauss-OM-6.0.0-CentOS7-x86_64.sha256openGauss-Server-6.0.0-CentOS7-x86_64.sha256upgrade_sql.tar.gzupgrade_sql.sha256

groupadd opengaussuseradd -g opengauss -s /bin/bash -md /home/opengauss opengaussid opengausspasswd opengauss
[root@VM-12-13-centos soft]# groupadd opengauss[root@VM-12-13-centos soft]# useradd -g opengauss -s /bin/bash -md /home/opengauss opengauss[root@VM-12-13-centos soft]# id opengaussuid=1001(opengauss) gid=1001(opengauss) groups=1001(opengauss)[root@VM-12-13-centos soft]# passwd opengaussChanging password for user opengauss.New password:Retype new password:passwd: all authentication tokens updated successfully.[root@VM-12-13-centos soft]#

mkdir -p /u01/5432/archivemkdir -p /u01/5432/gsdatamkdir -p /u01/5432/tempmkdir -p /u01/5432/logsmkdir -p /u01/5432/core_dumpchown -R  opengauss:opengauss /u01/5432/chmod 700 /u01/5432/gsdatamkdir -p /u01/app/opengausschown -R opengauss:opengauss /u01
[root@VM-12-13-centos soft]# ll /u01total 8drwxr-xr-x 7 opengauss opengauss 4096 Oct 25 16:09 5432drwxr-xr-x 3 opengauss opengauss 4096 Oct 25 16:09 app
把安装步骤1中的openGauss-Server-6.0.0-CentOS7-x86_64.tar.bz2包解压缩到/u01/app/opengauss[root@VM-12-13-centos soft]# tar -jxvf openGauss-Server-6.0.0-CentOS7-x86_64.tar.bz2 -C /u01/app/opengauss
chown -R opengauss:opengauss /u01/app/

切换到opengauss，下面使用opengauss账户来操作了su - opengaussvim .bash_profileexport GAUSSHOME=/u01/app/opengaussexport GAUSSDATA=/u01/5432/export PGPORT=5432export LD_LIBRARY_PATH=$GAUSSHOME/lib:$GAUSSHOME/lib/libsimsearch:$GAUSSHOME/script/gspylib/clib:$LD_LIBRARY_PATHexport PATH=$GAUSSHOME/bin:$PATHexport PGUSER=dbAdminexport GAUSSLOG=/u01/5432/logs
source .bash_profile

[opengauss@VM-12-13-centos ~]$ which gs_initdb/u01/app/opengauss/bin/gs_initdb
gs_initdb --nodename=gauss1 -D $GAUSSDATA/gsdata  --encoding=UTF-8 --locale=en_US.UTF-8  --username=dbAdmin --pwpasswd=opengauss@1234

创建一个实例成功后，可以看到下面信息WARNING: enabling "trust" authentication for local connectionsYou 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:
    gaussdb -D /u01/5432/gsdata --single_nodeor    gs_ctl start -D /u01/5432/gsdata -Z single_node -l logfile
[opengauss@VM-12-13-centos ~]$

[opengauss@VM-12-13-centos ~]$ gs_ctl start -D /u01/5432/gsdata -Z single_node -l logfile[2024-10-25 16:38:03.443][30727][][gs_ctl]: gs_ctl started,datadir is /u01/5432/gsdata[2024-10-25 16:38:03.475][30727][][gs_ctl]: waiting for server to start....[2024-10-25 16:38:04.482][30727][][gs_ctl]:  done[2024-10-25 16:38:04.482][30727][][gs_ctl]: server started (/u01/5432/gsdata)[opengauss@VM-12-13-centos ~]$
# 查看数据库状态[opengauss@VM-12-13-centos ~]$ ps -ef |grep gaussroot     25236 25974  0 16:20 pts/0    00:00:00 su - opengaussopengau+ 30730     1  1 16:38 ?        00:00:00 /u01/app/opengauss/bin/gaussdb -D /u01/5432/gsdataopengau+ 31094 25237  0 16:39 pts/0    00:00:00 grep --color=auto gauss[opengauss@VM-12-13-centos ~]$ gs_ctl status -D /u01/5432/gsdata/[2024-10-25 16:39:36.019][31246][][gs_ctl]: gs_ctl status,datadir is /u01/5432/gsdatags_ctl: server is running (PID: 30730)/u01/app/opengauss/bin/gaussdb "-D" "/u01/5432/gsdata"[opengauss@VM-12-13-centos ~]$
# 连接数据库，这里使用用户dbAdmin来连接数据库，密码是opengauss@1234[opengauss@VM-12-13-centos ~]$ gsql -p 5432 -d postgres -U dbAdmin -rPassword for user dbAdmin:gsql ((openGauss 6.0.0 build aee4abd5) compiled at 2024-09-29 18:38:08 commit 0 last mr  )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  | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin template1 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin(3 rows)
openGauss=#\q
# 停止数据库[opengauss@VM-12-13-centos ~]$ gs_ctl stop -D /u01/5432/gsdata[2024-10-25 16:45:45.617][696][][gs_ctl]: gs_ctl stopped ,datadir is /u01/5432/gsdatawaiting for server to shut down.... doneserver stopped

根据服务器资源，按实际情况配置$GAUSSDATA/gsdata/postgresql.confvi /u01/5432/gsdata/postgres.conflisten_addresses = '*'      local_bind_address = '0.0.0.0'port = 5432      max_connections = 1000log_directory = '/u01/5432/logs/'password_encryption_type = 0

vi /u01/5432/gsdata/pg_hba.confhost all all 0.0.0.0/0 md5

[opengauss@VM-12-13-centos ~]$ gs_ctl start -D /u01/5432/gsdata -Z single_node -l logfile[2024-10-25 16:53:06.551][2950][][gs_ctl]: gs_ctl started,datadir is /u01/5432/gsdata[2024-10-25 16:53:06.591][2950][][gs_ctl]: waiting for server to start....[2024-10-25 16:53:07.598][2950][][gs_ctl]:  done[2024-10-25 16:53:07.598][2950][][gs_ctl]: server started (/u01/5432/gsdata)[opengauss@VM-12-13-centos ~]$
[opengauss@VM-12-13-centos ~]$ gsql -d postgres -p 5432 -U dbAdmin -r
# 创建表空间openGauss=# CREATE TABLESPACE hello_data RELATIVE LOCATION 'tablespace/hello_data' ;CREATE TABLESPACEopenGauss=# \db             List of tablespaces    Name    |  Owner  |       Location------------+---------+----------------------- hello_data | dbAdmin | tablespace/hello_data pg_default | dbAdmin | pg_global  | dbAdmin |(3 rows)
# 创建数据库openGauss=# create database hello with encoding='UTF-8' LC_COLLATE='C' LC_CTYPE='C' DBCOMPATIBILITY='B' connection limit -1;CREATE DATABASEopenGauss=# \l                                List of databases   Name    |  Owner  | Encoding |   Collate   |    Ctype    |  Access privileges-----------+---------+----------+-------------+-------------+--------------------- hello     | dbAdmin | UTF8     | C           | C           | postgres  | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin template1 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin(4 rows)
# 创建用户ccuseropenGauss=# create user ccuser password 'Ccuser123!' default tablespace hello_data;NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.CREATE ROLE
# 磁盘上查看创建的表空间，其实是创建了一个表空间同名的目录[root@VM-12-13-centos tablespace]# pwd/u01/5432/gsdata/pg_location/tablespace[root@VM-12-13-centos tablespace]# lltotal 4drwx------ 3 opengauss opengauss 4096 Oct 25 17:03 hello_data
[opengauss@VM-12-13-centos ~]$ gsql -d hello -p 5432 -U dbAdmin -rPassword for user dbAdmin:gsql: FATAL:  could not load library "dblink.so": libltdl.so.7: cannot open shared object file: No such file or directoryCONTEXT:  SQL statement "create extension if not exists dblink;"
# 使用root用户安装包#yum install libltdl*
[opengauss@VM-12-13-centos ~]$ gsql -d hello -p 5432 -U dbAdmin -rPassword for user dbAdmin:gsql ((openGauss 6.0.0 build aee4abd5) compiled at 2024-09-29 18:38:08 commit 0 last mr  )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help.
hello=# \l                                List of databases   Name    |  Owner  | Encoding |   Collate   |    Ctype    |  Access privileges-----------+---------+----------+-------------+-------------+--------------------- hello     | dbAdmin | UTF8     | C           | C           | postgres  | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin template1 | dbAdmin | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/dbAdmin         +           |         |          |             |             | dbAdmin=CTc/dbAdmin(4 rows)
# 在hello库，给ccuser用户创建一个ccuser模式hello=# create schema ccuser authorization ccuser;