参考:http://my.oschina.net/zxu?disp=2&p=1&catalog=0
安装gis扩展:
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION fuzzystrmatch;
出错:
ERROR: could not open extension control file "/usr/local/pgsql/share/extension/fuzzystrmatch.control": No such file or directory
这个扩展已经包含在pgsql源码中,但是默认并未完成,所以需要安装之,进入pgsql源码目录:
cd contrib/fuzzystrmatch/
make
make install
然后再在pgsql命令行下执行:CREATE EXTENSION fuzzystrmatch;