现在的位置: 首页 > 综合 > 正文

Install PostgreSql and PostGIS On Ubuntu Server

2019年04月17日 ⁄ 综合 ⁄ 共 560字 ⁄ 字号 评论关闭

  There is an article[1] for installing PostgreSQL on Ubuntu. [2] actually is a even better one if you want to install PostgreSQL and PostGIS at the same time.

  In order to use PostGIS in database, you need to execute two commands below[3] in every database that you want to have PostGIS extension.

-- Enable PostGIS (includes raster)
CREATE EXTENSION postgis;
-- Enable Topology
CREATE EXTENSION postgis_topology;

Reference:

[1]https://www.digitalocean.com/community/articles/how-to-install-and-use-postgresql-on-ubuntu-12-04

[2]http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

[3]http://postgis.net/install/


抱歉!评论已关闭.