linux环境下创建postgis数据库,linux下搭建postgresql、postgis、pg_pathman环境步骤详解...
操作系统：centOS6.6
安装postgreSQL9.6.2
安装命令：
./postgresql-9.6.3-2-linux-x64.run
之后按照图形界面操作安装，语言选择zh_CN UTF-8
安装geos-3.6.0(会报错，暂时不用管)
安装命令：
tar xjvfgeos-3.6.0.tar.bz2
cd geos-3.6.0
./configure –prefix=/opt/geos
make
make install
安装proj-4.9.3
安装命令：
tar zxvf proj-4.9.3.tar.gz
cd proj-4.9.3
./configure –prefix=/opt/proj
make
make install
安装gdal-2.1.2
安装命令：
yum install gcc-c++
tar zxvf gdal-2.1.2.tar.gz
cd gdal-2.1.2
./configure –prefix=/opt/gdal
make
make install
删除geos相关的文件夹
cd /opt
rm –rf geos
rm –rf geos-3.6.0
重新安装geos-3.6.0，步骤如上
安装postgis
安装命令：
export LD_LIBRARY_PATH=/opt/PostgreSQL/9.6/lib
export PATH=/opt/PostgreSQL/9.6/bin:$PATH
export MANPATH=/opt/PostgreSQL/9.6/share/man:$MANPATH
tar zxvf postgis-2.3.2.tar.gz
cd postgis-2.3.2
./configure -prefix=/opt/postgis
报错如下：
checking for xml2-config… no
configure: error: could not find xml2-config from libxml2within the current path. You may need to try re-running configure with a–with-xml2config parameter.
checking for xml2-config… no
configure: error: could not find xml2-config from libxml2within the current path. You may need to try re-running configure with a–with-xml2config parameter.
检查libxml2的安装情况：
rpm -qa |grep libxml2
重新安装libxml2和libxml2-devel包(需要联网)
yum install libxml2
yum install libxml2-devel -y
安装完之后查找xml2-config文件是否存在：
find / -name “xml2-config”
如果输出结果如下表示成功：
/usr/bin/xml2-config
继续执行如下命令：
./configure –prefix=/opt/postgis/–with-pgconfig=/opt/PostgreSQL/9.6/bin/pg_config–with-geosconfig=/opt/geos/bin/geos-config –with-projdir=/opt/proj/–with-gdalconfig=/opt/gdal/bin/gdal-config–with-xml2config=/usr/bin/xml2-config
make
make install
打开postgresql终端执行
SELECT name,default_version,installed_version FROM pg_available_extensions WHERE name LIKE’postgis%’ ;
执行命令：
cp/opt/geos/lib/libgeos_c.so.1 /opt/PostgreSQL/9.6/lib
执行命令：
cp/opt/proj/lib/libproj.so.12 /opt/PostgreSQL/9.6/lib
执行命令：
cp /opt/gdal/lib/libgdal.so.20 /opt/PostgreSQL/9.6/lib
创建postgis扩展
安装pg_pathman
安装命令：
cd /opt
unzippg_pathman-1.2.1.zip
export PATH=/opt/PostgreSQL/9.6/bin:$PATH
cd pg_pathman-1.2.1
cp -r/opt/PostgreSQL/9.6/include/openssl /usr/include/
cp -r/opt/PostgreSQL/9.6/include/gssapi /usr/include/
make USE_PGXS=1
make USE_PGXS=1install
cd/opt/PostgreSQL/9.6/data/
vimpostgresql.conf
#将shared_preload_libraries注释取消，将下面变量赋值进去
shared_preload_libraries= ‘pg_pathman,pg_stat_statements’
按esc退出，:wq!保存退出！
重启数据库服务：
service postgresql-9.6 restart
创建pg_pathman扩展
开启远程访问：
vi /opt/PostgreSQL/9.6/data/postgresql.conf
修改#listen_addresses= ‘localhost’ 为 listen_addresses=’*’
当然，此处‘*’也可以改为任何你想开放的服务器IP
信任远程连接
vi /opt/PostgreSQL/9.6/data/pg_hba.conf
修改如下内容，信任指定服务器连接
关闭防火墙
service iptables stop
chkconfig iptables off
service iptables status
重启数据库服务：
servicepostgresql-9.6 restart
转载自：https://blog.csdn.net/qq_26629277/article/details/75579166