1.打开postgis安装路径下的sql Shell，会弹出命令行对话框
3.敲入创建数据库命令：
create database mydatabase;
\c mydatabases;
CREATE EXTENSIONpostgis;
CREATE EXTENSIONpgrouting;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION address_standardizer;
原文链接：https://www.f2er.com/postgresql/195195.html