cd ~ wget http://tar.matosiki.site/tar/proj-5.2.0.tar.gz tar -zxvf proj-5.2.0.tar.gz cd proj-5.2.0 ./configure --prefix=/usr/local/proj make && make install
wget http://tar.matosiki.site/tar/geos-3.7.1.tar.bz2 bzip2 -d geos-3.7.1.tar.bz2 tar vxf geos-3.7.1.tar cd geos-3.7.1 ./configure --prefix=/usr/local/geos make && make install
tar -zxvf gdal-2.4.0.tar.gz wget http://tar.matosiki.site/tar/gdal-2.4.0.tar.gz cd gdal-2.4.0 ./configure --prefix=/usr/local/gdal make && make install
wget http://tar.matosiki.site/tar/postgis-2.5.1.tar.gz tar -zxvf postgis-2.5.1.tar.gz cd postgis-2.5.1 ./configure --with-pgconfig=/usr/local/postgres/bin/pg_config --with-geosconfig=/usr/local/geos/bin/geos-config --with-projdir=/usr/local/proj --with-gdalconfig=/usr/local/gdal/bin/gdal-config --with-jsondir=/usr/include/json-c make & make install
到postgresql源码目录的contrib/fuzzystrmatch下直接make & make install安装该插件
重启数据库,执行以下查询验证插件是否安装成功
/usr/local/pgsql/contrib/fuzzystrmatch ./configure --with-pgconfig=/usr/local/postgres/bin/pg_config --with-geosconfig=/usr/local/geos/bin/geos-config --with-projdir=/usr/local/proj --with-gdalconfig=/usr/local/gdal/bin/gdal-config --with-jsondir=/usr/include/json-c make & make install
select \* from pg_available_extensions wherenamelike'postgis%';