关于postgis:源码编译安装postgis

内容概述
PG14装置postgis 3.2.1为例子，centos 7.9下
postgis是独立发行的pg extension，它依赖于一系列的包，须要独自装置。本文只笼罩起码依赖，有些高级性能依赖的包如SFCGAL等没有波及。

有的依赖包零碎可能曾经装置过了，能够相应的确认版本是否满足要求

yum list  |grep geos
yum list installed |grep geos
yum remove geos

选项1：通过yum装置依赖包

# > 0.9
sudo yum install json-c
# > 2.5
sudo yum install libxml2
# > 4.9
sudo yum install proj
# > 3.6
sudo yum install geos
# > 2
sudo yum install gdal

选项1：通过源码编译装置依赖包
centos装置源版本比拟老，可能不满足要求，须要源码编译装置

mkdir -p /usr/local/libpostgis

sqlite3

sqlite-autoconf-3380400/
./configure --prefix=/usr/local/libpostgis/sqlite3
make
make install

mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
ln -s /usr/local/libpostgis/sqlite3/bin/sqlite3 /usr/bin/sqlite3
ll /usr/bin/sqlite3
echo "/usr/local/libpostgis/sqlite3/lib" > /etc/ld.so.conf.d/sqlite3.conf
ll /usr/local/libpostgis/sqlite3/
ldconfig
sqlite3 --version

export PKG_CONFIG_PATH=/usr/local/libpostgis/sqlite3/lib/pkgconfig:$PKG_CONFIG_PATH

proj

./configure --prefix=/usr/local/libpostgis/proj

make && make install
echo "/usr/local/libpostgis/proj/lib" > /etc/ld.so.conf.d/proj-6.3.1.conf
ldconfig

export PKG_CONFIG_PATH=/usr/local/libpostgis/proj/lib/pkgconfig:$PKG_CONFIG_PATH

geos

./configure --prefix=/usr/local/libpostgis/geos
make && make install
echo "/usr/local/libpostgis/geos/lib" > /etc/ld.so.conf.d/geos-3.8.0.conf
ldconfig

gdal

./configure  --prefix=/usr/local/libpostgis/gdal --with-proj=/usr/local/libpostgis/proj
make && make install
echo "/usr/local/libpostgis/gdal/lib" > /etc/ld.so.conf.d/gdal-3.4.3.conf
ldconfig

protobuf

./autogen.sh  --prefix=/usr/local/libpostgis/protobuf
./configure  --prefix=/usr/local/libpostgis/protobuf
make && make install
echo "/usr/local/libpostgis/protobuf/lib" > /etc/ld.so.conf.d/protobuf-3.20.1.conf
ldconfig

export PKG_CONFIG_PATH=/usr/local/libpostgis/protobuf/lib/pkgconfig:$PKG_CONFIG_PATH

protobuf-c

./autogen.sh  --prefix=/usr/local/libpostgis/protobuf-c
./configure  --prefix=/usr/local/libpostgis/protobuf-c
make && make install
echo "/usr/local/libpostgis/protobuf-c/lib" > /etc/ld.so.conf.d/protobuf-c-1.4.0.conf
ldconfig

export PKG_CONFIG_PATH=/usr/local/libpostgis/protobuf/lib/pkgconfig:$PKG_CONFIG_PATH

源码编译装置pg数据库

./configure
make && make install
initdb -D DTAT_DIR
pg_ctl -D DTAT_DIR start

// 如果pg是源码编译装置的，须要指定&＃8211;prefix为pg的install目录，以及相应的pgconfig
// geosgdal等为源码编译装置的，须要指定geosconfig、gdalconfig

./configure  --prefix=/home/work/pg/install --with-pgcOnfig=/home/work/pg/install/bin/pg_config --with-geoscOnfig=/usr/local/libpostgis/geos/bin/geos-config  --with-gdalcOnfig=/usr/local/libpostgis/gdal/bin/gdal-config
make && make install

启动pg，装置postgis

psql -p 5980
postgre=# create extension postgis;

参考资料
postgis install &＃8211; 内含各依赖包的地址