mogdb数据库全生命周期管理-地理坐标gis安装

原作者：周琦放

如无特殊说明，请在所有节点执行，执行用户为root

组件下载

下载gis组件：Yukon-1.0-Alpha-openGauss2.1.0-CentOS_x64.tar.gz,请注意下载的组件版本一定要和数据库版本严格一致

下载地址https://gitee.com/opengauss/Yukon/releases/v1.0-alpha

环境配置要求

本次安装使用的是root 用户进行安装，而opengauss数据库的系统用户为omm，需要把omm用户的环境变量配置到root下的/etc/profile中，

如下：加粗部分为omm的环境变量，请根据实际情况修改，omm用户的环境变量一般在/home/omm/.bashrc

more /etc/profile ......export ORACLE_HOME=/root/ora2pg/instantclient_11_2export PATH=$PATH:$ORACLE_HOMEexport LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATHexport TNS_ADMIN=$ORACLE_HOMEexport PYTHON_HOME=/usr/local/python3export PATH=$PATH:$PYTHON_HOME/bin**export PATH=/root/gauss_om/omm/script:$PATH****export GPHOME=/opt/huawei/install/om****export PATH=$GPHOME/script/gspylib/pssh/bin:$GPHOME/script:$PATH****export LD_LIBRARY_PATH=$GPHOME/lib:$LD_LIBRARY_PATH****export PYTHONPATH=$GPHOME/lib****export GAUSSHOME=/opt/huawei/install/app****export PATH=$GAUSSHOME/bin:$PATH****export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH****export S3_CLIENT_CRT_FILE=$GAUSSHOME/lib/client.crt****export GAUSS_VERSION=2.1.0****export PGHOST=/opt/huawei/tmp****export GAUSSLOG=/var/log/omm/omm****umask 077****export GAUSS_ENV=2****export GS_CLUSTER_NAME=Cluster01**
复制

安装Yukon gis组件

tar -zxvf Yukon-1.0-Alpha-openGauss2.1.0-CentOS_x64.tar.gzcd Yukon-1.0-Alpha-openGauss2.1.0/Yukon-1.0/sh install_yukon.sh -i
复制

安装日志：出现以下日志表示安装成功

__ __ \ \ / / | | \ _/ / _ | | __ ___ _ __ \ /| | | || |/ // _ \ | _ \ | | | || || <| () || | | | || __|||_\_/ || ||

验证测试

[omm@ogpri ~]$ gsql -d postgres -p 26000gsql ((openGauss 2.1.0 build 590b0f8e) compiled at 2021-09-30 14:29:04 commit 0 last mr  )Non-SSL connection (SSL connection is recommended when requiring high-security)Type "help" for help. openGauss=# create database test;  CREATE DATABASEopenGauss=# \c test;Non-SSL connection (SSL connection is recommended when requiring high-security)You are now connected to database "test" as user "omm".test=# **create extension postgis;****CREATE EXTENSION**test=# 
复制