1
2
3
4
5
6
7
8

# 拉取镜像
docker pull supermap/yukon:1.0.1-opengauss3.1.0-amd64

# 重命名镜像
docker tag supermap/yukon:1.0.1-opengauss3.1.0-amd64 192.168.9.30/dtd_gis/yukon-1.0.1-opengauss3.1.0-amd64

# 推送到192.168.9.30服务器
docker push 192.168.9.30/dtd_gis/yukon-1.0.1-opengauss3.1.0-amd64

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

version : '3'

services :
  yukon-opengauss:
    image : 192.168.9.30/dtd_gis/yukon-1.0.1-opengauss3.1.0-amd64
    container_name : yukon-opengauss
    ports :
      - "5434:5432"
    environment:
      - GS_USERNAME=postgres
      # 必须包含大小写、特殊字符、长度大于8
      - GS_PASSWORD=Admin@123
    restart: always
    privileged: true
    volumes:
      - ./data:/var/lib/opengauss/data

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

docker-compose up -d

docker exec -it yukon-opengauss /bin/bash

su omm

gsql -d postgres -p 5432

alter user postgres with sysadmin;
alter user postgres with createdb;

\q

1
2
3

max_connections = 500
failed_login_attempts = 0
password_min_length = 0

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

# 创建数据库
gsql -d postgres -p 5432
create database data_platform owner postgres;
\q

# 初始化postgis插件
gsql -d data_platform -p 5432
CREATE EXTENSION postgis;
create extension pgrouting;
create extension postgis_raster;

1
2
3

docker pull registry.cn-beijing.aliyuncs.com/supermap/yukon:2.1-postgresql13-amd64
docker tag registry.cn-beijing.aliyuncs.com/supermap/yukon:2.1-postgresql13-amd64 192.168.9.30/dtd_gis/yukon-1.0.1-postgresql13-amd64
docker push 192.168.9.30/dtd_gis/yukon-1.0.1-postgresql13-amd64

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

version : '3'

services :
  yukon-postgresql13:
    image : 192.168.9.30/dtd_gis/yukon-1.0.1-postgresql13-amd64
    container_name : yukon-postgresql13
    ports :
      - "5436:5432"
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=Admin@123
      - PASSWORD_AUTHENTICATION="md5"
      - POSTGIS_GDAL_ENABLED_DRIVERS='ENABLE_ALL'
      - POSTGIS_ENABLED_OUTDB_RASTERS=1
    restart: always
    privileged: true
    volumes:
      - ./data:/var/lib/postgresql/data

1

docker-compose up -d

1
2
3

create extension postgis;
create extension pgrouting;
create extension postgis_raster;