
回复
[root@localhost ~]# yum install libaio-devel flex bison ncurses-devel glibc-devel patch redhat-lsb-core readline-devel libnsl
vim /etc/selinux/config
修改config文件,将SELINUX的值变为"disabled"
检测防火墙是否关闭
systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
vim /etc/profile在行尾添加
export LANG=en_US.UTF-8
swapoff -a
(当内存较小时,可打开)
(因为使用的环境为CentOS,默认关闭)
[root@localhost opt]# useradd opengauss
[root@localhost opt]# mkdir -p /opt/opengauss
[root@localhost tmp]# tar -jxf openGauss-5.0.0-CentOS-64bit.tar.bz2 -C /opt/opengauss
[root@localhost tmp]# cd /opt/opengauss/
[root@localhost opengauss]# chmod 755 -R /opt/opengauss
[root@localhost opengauss]# chown -R opengauss /opt/opengauss
[root@localhost opengauss]# sudo -iu opengauss
[opengauss@localhost ~]$ cd /opt/opengauss/simpleInstall
[opengauss@localhost simpleInstall]$ sh install.sh -w "52@openGauss" &&source ~/.bashrc
(注意:如果出现这种错误,请使用拥有root权限的用户执行sysctl -w kernel.sem="250 85000 250 330"
即可)
[opengauss@localhost ~]$ ps -ef | grep gauss
opengau+ 4946 1 3 11:20 ? 00:08:09 /opt/opengauss/bin/gaussdb -D /opt/opengauss/data/single_node
root 10843 3518 0 14:04 pts/0 00:00:00 sudo -iu opengauss
root 19289 3846 0 15:50 pts/1 00:00:00 sudo -iu opengauss
opengau+ 19387 19291 0 15:51 pts/1 00:00:00 grep --color=auto gauss
也可以使用gs_ctl status
命令,判断数据库状态:
[opengauss@localhost ~]$ gs_ctl status
[2023-07-05 15:53:37.581][19531][][gs_ctl]: gs_ctl status,datadir is /opt/opengauss/data/single_node
gs_ctl: server is running (PID: 4946)
/opt/opengauss/bin/gaussdb "-D" "/opt/opengauss/data/single_node"
[opengauss@localhost ~]$ gs_ctl notify
[2023-07-05 16:00:42.972][20104][][gs_ctl]: gs_ctl notify ,datadir is /opt/opengauss/data/single_node
[2023-07-05 16:00:42.973][20104][][gs_ctl]: the parameter of notify must be specified
可以使用select version()
查看数据库版本,使用show server_version
查看pg基础版本
\l
查看当前有哪些数据库
\c
查看当前会话连接信息
\db
查看有哪些表空间
\du
查看用户和角色
\dn
查看当前数据库有哪些schema
\dt
查看数据库中所有表
openGauss=# CREATE USER test1 IDENTIFIED BY 'opengauss@2023';
CREATE ROLE
openGauss=# ALTER USER test1 CREATEROLE;
ALTER ROLE
openGauss=# create table test0707(id CHAR(2) NOT NULL,update_user VARCHAR(20) NOT NULL);
CREATE TABLE
openGauss=# insert into test0707(id,update_user) values(1,'Bob');
INSERT 0 1
创建了两个schema
openGauss=# create schema t1 AUTHORIZATION test1;
CREATE SCHEMA
openGauss=# create schema t2 AUTHORIZATION test1;
CREATE SCHEMA
在不同schema下创建表名均为test01的表,插入不同数据
openGauss=# create table t1.test01(id CHAR(2) NOT NULL,update_user VARCHAR(20) NOT NULL);
CREATE TABLE
openGauss=# insert into t1.test01(id,update_user) values(2,'Tom');
INSERT 0 1
openGauss=# create table t2.test01(id CHAR(2) NOT NULL,update_user VARCHAR(20) NOT NULL);
CREATE TABLE
openGauss=# insert into t2.test01(id,update_user) values(3,'Nancy');
INSERT 0 1
通过结果可以看出,不切换对应schema,是无法进行查看其他schema的内容
本文简单描述了openGauss的安装与使用,可供初学者进行参考,希望openGauss越做越好
文章转载自公众号:openGauss