PostGIS源代碼安裝指南

前言

使用PostGIS提供的st_asmvt函數(shù)返回MapBox格式的矢量切片時(shí)，PostGIS報(bào)錯(cuò)missing libprotobuf-c，為了解決這個(gè)問題，需要從源碼編譯postgis，添加對protobuf的支持，特此記錄。

1.安裝postgresql

通過yum安裝postgresql10 ，安裝目錄/var/lib/pgsql/10

2.安裝gcc

yum install -y gcc gcc-c++

3.編譯安裝GEOS

cd /mysoft
wget https://download.osgeo.org/geos/geos-3.7.0.tar.bz2
tar -jxvf geos-3.7.0.tar.bz2
cd geos-3.7.0
./configure --prefix=/usr/local/geos-3.7.0
make
make install

4.編譯安裝Proj

wget http://download.osgeo.org/proj/proj-5.2.0.tar.gz
tar -zxvf proj-5.2.0.tar.gz
cd proj-5.2.0
./configure  --prefix=/usr/local/proj-5.2.0
make
make install

5.編譯安裝GDAL

wget https://download.osgeo.org/gdal/2.3.2/gdal-2.3.2.tar.gz
tar -zxvf gdal-2.3.2.tar.gz
cd gdal-2.3.2
./configure  --prefix=/usr/local/gdal-2.3.2 --with-pg=/usr/pgsql-10/bin/pg_config
make
make install

6.編譯安裝json-c，添加對geojson支持

wget https://github.com/json-c/json-c/archive/json-c-0.13.1-20180305.tar.gz
tar -zxvf json-c-0.13.1-20180305.tar.gz
cd json-c-0.13.1-20180305
./configure  --prefix=/usr/local/json-c-0.13.1
make
make install

7.編譯安裝libxml2

wget https://github.com/GNOME/libxml2/archive/v2.9.7.tar.gz
tar -zxvf libxml2-sources-2.9.7.tar.gz
cd libxml2-2.9.7
./configure  --prefix=/usr/local/libxml2-2.9.7
make
make install

8.編譯安裝protobuf

wget https://github.com/google/protobuf/releases/download/v3.6.1/protobuf-all-3.6.1.tar.gz
tar zxvf protobuf-all-3.6.1.tar.gz
./autogen.sh
#配置安裝目錄
./configure  --prefix=/usr/local/protobuf-3.6.1
make
make install
#配置環(huán)境變量，增加/usr/local/protobuf-3.6.1安裝目錄
vi /etc/profile
export CMAKE_HOME=/usr/bin/cmake
export PKG_CONFIG_PATH=/usr/local/protobuf-3.6.1/lib/pkgconfig
export PROTOBUF_HOME=/usr/local/protobuf-3.6.1
export PATH=$CMAKE_HOME/bin:$PROTOBUF_HOME/bin:$PATH
#保存退出
source /etc/profile
#驗(yàn)證protobuf執(zhí)行程序
protoc --version
#出現(xiàn)libprotoc 3.6.1說明安裝成功

9.安裝protobuf-c

wget https://github.com/protobuf-c/protobuf-c/releases/download/v1.3.1/protobuf-c-1.3.1.tar.gz
tar -zxvf protobuf-c-1.3.1.tar.gz    
cd protobuf-c-1.3.1  
#導(dǎo)入protobuf的pkgconfig，否則"--No package 'protobuf' found"
export PKG_CONFIG_PATH=/usr/local/protobuf-3.6.1/lib/pkgconfig
./configure  --prefix=/usr/local/protobuf-c-1.3.1
make    
make install   
#配置環(huán)境變量，增加下protobuf-c-1.3.1/bin
vi /etc/profile
export PATH=:/usr/local/protobuf-c-1.3.1/bin
#保存退出
source /etc/profile

10.安裝cgal，根據(jù)遙想公瑾當(dāng)年的簡書所述，安裝cgal不能指定安裝目錄

#boost
[root@VM_0_4_centos opt]#  yum install boost-devel
# 安裝指定版本cgal-4.13
[root@VM_0_4_centos opt]# wget https://github.com/CGAL/cgal/archive/releases/CGAL-4.13.tar.gz
[root@VM_0_4_centos opt]# tar -zxvf CGAL-4.13.tar.gz   
[root@VM_0_4_centos opt]# cd CGAL-4.13  
[root@VM_0_4_centos CGAL-4.13]#mkdir build & cd build 
#cmake不要指定安裝路徑
[root@VM_0_4_centos build]# cmake ..
[root@VM_0_4_centos build]# make    
[root@VM_0_4_centos build]# make install

10.安裝sfcgal

wget https://github.com/Oslandia/SFCGAL/archive/v1.3.6.tar.gz
tar -zxvf v1.3.6.tar.gz   
cd SFCGAL-1.3.6  
mkdir build & cd build 
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/sfcgal-1.3.6 ..
make    
make install

10.編譯安裝postgis

10.1配置ld.so.conf

[root@VM_0_4_centos opt]# vim /etc/ld.so.conf
#編輯內(nèi)容如下
include ld.so.conf.d/*.conf
/home/postgres/lib
/usr/local/proj-5.2.0/lib
/usr/local/gdal-2.3.2/lib
/usr/local/geos-3.7.0/lib
/usr/local//sfcgal-1.3.6/lib64
/usr/local/json-c-0.13.1/lib
/usr/local/libxml2-2.9.7/lib
/usr/local/protobuf-3.6.1/lib
/usr/local/protobuf-c-1.3.1/lib
#編輯完成后wq!保存退出
#保存配置，重啟生效
[root@VM_0_4_centos opt]# ldconfig -v

10.2編譯安裝

wget http://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz    
tar -zxvf postgis-2.5.0.tar.gz    
cd postgis-2.5.0 
#根據(jù)安裝不同的要求，選擇任意一個(gè)configure
#基本安裝，不帶protobuf,sfcgal
./configure --prefix=/home/postgres --with-gdalconfig=/usr/local/gdal-2.3.2/bin/gdal-config --with-pgconfig=/home/postgres/bin/pg_config --with-geosconfig=/usr/local/geos-3.7.0/bin/geos-config --with-projdir=/usr/local/proj-5.2.0 --with-xml2config=/usr/local/libxml2-2.9.7/bin/xml2-config --with-jsondir=/usr/local/json-c-0.13.1
#帶protobuf安裝，支持mvt
./configure --prefix=/home/postgres --with-gdalconfig=/usr/local/gdal-2.3.2/bin/gdal-config --with-pgconfig=/home/postgres/bin/pg_config --with-geosconfig=/usr/local/geos-3.7.0/bin/geos-config --with-projdir=/usr/local/proj-5.2.0 --with-xml2config=/usr/local/libxml2-2.9.7/bin/xml2-config --with-jsondir=/usr/local/json-c-0.13.1 --with-protobufdir=/usr/local/protobuf-c-1.3.1
# 帶protobuf,sfcgal安裝
./configure --prefix=/home/postgres --with-gdalconfig=/usr/local/gdal-2.3.2/bin/gdal-config --with-pgconfig=/home/postgres/bin/pg_config --with-geosconfig=/usr/local/geos-3.7.0/bin/geos-config --with-projdir=/usr/local/proj-5.2.0 --with-xml2config=/usr/local/libxml2-2.9.7/bin/xml2-config --with-jsondir=/usr/local/json-c-0.13.1 --with-protobufdir=/usr/local/protobuf-c-1.3.1 --with-sfcgal=/usr/local/sfcgal-1.3.6/bin/sfcgal-config

make
make install
最后編輯于 ：
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時(shí)請結(jié)合常識與多方信息審慎甄別。
平臺聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡書系信息發(fā)布平臺，僅提供信息存儲服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容