vastbase配置postgis

首先获取vastbase对应的postgis版本包，和海量数据库的技术人员沟通获取

海量数据库安装目录：/home/vastbase/local/vastbase_29012

• 解压,配置postgis库目录

mkdir /opt/postgis
tar xf Postgis_3_2_0\(6636\)_Vastbase_G100_2.2.19\(29012\)_Linux_kunpeng920_20251201.tar.gz -C /opt/postgis


#授权
chown -R vastbase:vastbase   /opt/postgis/postgis

#拷贝
cp -a  /opt/postgis/postgis/*  /home/vastbase/local/vastbase_29012/


#拷贝库文件到 系统库目录
cd /usr/lib64
cp /opt/postgis/postgis/lib/libgeos_c.so.1 ./
cp /opt/postgis/postgis/lib/libjson-c.so.2 ./
cp /opt/postgis/postgis/lib/libSFCGAL.so.1 ./
cp /opt/postgis/postgis/lib/libproj.so.15  ./
cp /opt/postgis/postgis/lib/libCGAL_Core.so.13 ./
cp /opt/postgis/postgis/lib/libboost_thread.so.1.71.0 ./
cp /opt/postgis/postgis/lib/libboost_system.so.1.71.0 ./
cp /opt/postgis/postgis/lib/libCGAL.so.13 ./
cp /opt/postgis/postgis/lib/libgeos.so.3.10.2 ./
cp /opt/postgis/postgis/lib/libboost_serialization.so.1.71.0 ./


#重启
su - vastbase

vb_ctl restart

#只出现过一次
[vastbase@vdb1 lib64]$ vb_ctl status
vb_ctl: symbol lookup error: vb_ctl: undefined symbol: PQsetRwTimeout

#重新进入，或者配置 ld path 正常了
export LD_LIBRARY_PATH=/home/vastbase/local/vastbase_29012/lib:$LD_LIBRARY_PATH