每个库需要执行postgis命令
CREATE extension postgis;
CREATE extension postgis_topology;
CREATE extension fuzzystrmatch;
CREATE extension address_standardizer;
CREATE extension address_standardizer_data_us;
CREATE extension postgis_tiger_geocoder;
原文：https://www.cnblogs.com/zhao907/p/14611239.html