使用Docker、navicat部署和连接GaussDB

朴灿烈づ我的快乐病毒、 2024-03-26 16:24 84阅读 0赞

## 一、在CentOS7上安装Docker工具 ##

![0b09c0aa0455469ea24461eff1f1cc60.png][]

### 1.卸载之前老版本的Docker ###

yum remove docker \
                      docker-client \
                      docker-client-latest \
                      docker-common \
                      docker-latest \
                      docker-latest-logrotate \
                      docker-logrotate \
                      docker-selinux \
                      docker-engine-selinux \
                      docker-engine \
                      docker-ce

### 2.安装Docker ###

首先虚拟机要联网，安装yum工具

yum install -y yum-utils \
               device-mapper-persistent-data \
               lvm2 --skip-broken

然后更新本地镜像源：

# 设置docker镜像源
    yum-config-manager \
        --add-repo \
        https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
        
    sed -i 's/download.docker.com/mirrors.aliyun.com\/docker-ce/g' /etc/yum.repos.d/docker-ce.repo
     
    yum makecache fast

然后输入命令：

yum install -y docker-ce

docker-ce为社区免费版本。稍等片刻，docker即可安装成功。

### 3.启动Docker ###

systemctl start docker  # 启动docker服务
     
    systemctl stop docker  # 停止docker服务
     
    systemctl restart docker  # 重启docker服务

### 4.配置镜像加速 ###

参考阿里云的镜像加速文档：https://cr.console.aliyun.com/cn-hangzhou/instances/mirrors

sudo mkdir -p /etc/docker
    sudo tee /etc/docker/daemon.json <<-'EOF'
    {
      "registry-mirrors": ["https://v5np4yet.mirror.aliyuncs.com"]
    }
    EOF
    sudo systemctl daemon-reload
    sudo systemctl restart docker

### 二、使用Docker部署GaussDB ###

![dfb59600163b43a193453d4681e17ed2.png][]

### 1.拉取gauss镜像 ###

docker pull enmotech/opengauss

![1cd50a7d2fec48e2830110aa383384da.png][]

### 2.创建并运行容器 ###

docker run --name opengauss1 --privileged=true -p 5432:5432 -d -e GS_PASSWORD=Bls@123456 enmotech/opengauss:latest

docker ps

![cf5041382d944a45a75c6a289672fb26.png][]

一般使用的连接用户gaussdb，密码是Bls@123456

### 3.开放5432端口 ###

firewall-cmd --zone=public --add-port=5432/tcp --permanent
    firewall-cmd --reload

## 三、使用Navicat来连接GaussDB ##

### 1.在navicat中找到PostgreSQL...连接 ###

![a843bf2881a3419ebcb2330f7042a450.png][]

### 2.填写信息即可连接 ###

![4b29a787bc844e77895dab5e9dda2ac5.png][]

[0b09c0aa0455469ea24461eff1f1cc60.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/6efb0387aaf44277963518c64db32738.png
[dfb59600163b43a193453d4681e17ed2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/050a36aae1c746ebb15c5d795af178d0.png
[1cd50a7d2fec48e2830110aa383384da.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/a5b328618d2f40e7814754cda526e7c3.png
[cf5041382d944a45a75c6a289672fb26.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/fe43ca96b1444b20b299d0bccddb85d1.png
[a843bf2881a3419ebcb2330f7042a450.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/49f7c0c99d684aac8363a620b4bc59e7.png
[4b29a787bc844e77895dab5e9dda2ac5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/1286fe8a36924afca4e287a557ab3da9.png