参考：https://cloud.tencent.com/developer/article/2516239

安装docker

下载docker安装包

wget https://download.docker.com/linux/static/stable/x86_64/docker-29.7.1.tgz

tar -zxvf docker-29.7.1.tgz
cp docker/* /usr/bin/
vim /usr/lib/systemd/system/docker.service

# 刷新 iptables 规则
sudo iptables -t nat -F
sudo iptables -t nat -X

配置 docker.service

vim /usr/lib/systemd/system/docker.service
## 内容如下：

[Unit]
Description=Docker Application Container Engine
Documentation=https://docs.docker.com
After=network-online.target firewalld.service
Wants=network-online.target
[Service]
Type=notify
EnvironmentFile=-/etc/default/docker
ExecStart=/usr/bin/dockerd
ExecReload=/bin/kill -s HUP
LimitNOFILE=infinity
LimitNPROC=infinity
TimeoutStartSec=0
Delegate=yes
KillMode=process
Restart=on-failure
StartLimitBurst=3
StartLimitInterval=60s
[Install]
WantedBy=multi-user.target

配置 daemin.json

mkdir /etc/docker
vim /etc/docker/daemon.json
## 内容如下：

{
        "data-root": "/opt/docker",
        "log-driver": "json-file",
        "log-opts": {"max-size":"500m", "max-file":"4"},
        "default-ulimits": {"nofile": {"Name": "nofile","Hard": 64000,"Soft": 64000}}
}

启动

systemctl daemon-reload
systemctl start docker
systemctl enable docker
docker version

安装openGauss

官方文档：https://docs.opengauss.org/zh/docs/6.0.0/docs/InstallationGuide/%E5%AE%B9%E5%99%A8%E9%95%9C%E5%83%8F%E5%AE%89%E8%A3%85.html

参考：https://blog.csdn.net/weixin_50495215/article/details/148610589

yum install -y libaio-devel readline-devel expect tar net-tools
systemctl stop firewalld.service
wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/6.0.5/openGauss-Docker-6.0.5-x86_64.tar
docker load -i openGauss-Docker-6.0.5-x86_64.tar
mkdir -p /home/opengauss/data
docker run --name opengauss --privileged=true -d -p 5432:5432 -e GS_PASSWORD=YourPassoword  -v /home/opengauss/data:/var/lib/opengauss  opengauss:6.0.5

# 常用命令
## 查看所有用户
\du

## 创建用户
CREATE USER sysadmin WITH SYSADMIN password "123456";

## 将某个schema授权给用户
grant all on ALL TABLES IN SCHEMA test to sysadmin;

## 切换数据库
\c test

## 查看所有schema
\dn
\dn+

## 查看所有表
\dt

## 创建数据库
CREATE DATABASE test;

## 创建表
CREATE TABLE public.user_info
(
    id character varying NOT NULL,
    name character varying,
    age integer,
    height double precision,
    birthday timestamp without time zone,
    PRIMARY KEY (id)
);
ALTER TABLE IF EXISTS public.user_info OWNER to sysadmin;
COMMENT ON TABLE public.user_info IS '用户信息表';
COMMENT ON COLUMN public.user_info.name IS '姓名';
COMMENT ON COLUMN public.user_info.age IS '年龄';
COMMENT ON COLUMN public.user_info.height IS '身高';
COMMENT ON COLUMN public.user_info.birthday IS '生日';