Greenplum 4.3.x 安装postgis

下载Greenplum的postgis插件

https://network.pivotal.io/products/pivotal-gpdb/#/releases/4540/file_groups/493

执行：

gppkg -i postgis-ossv2.0.3_pv2.0.1_gpdb4.3-rhel5-x86_64.gppkg

即可完成安装

执行如下测试例子：

psql -d mydatabase -f 
  $GPHOME/share/postgresql/contrib/postgis-2.0/postgis.sql
psql -d mydatabase -f 
  $GPHOME/share/postgresql/contrib/postgis-2.0/spatial_ref_sys.sql

CREATE TABLE geotest (id INT4, name VARCHAR(32) );
SELECT AddGeometryColumn('geotest','geopoint', 4326,'POINT',2);
INSERT INTO geotest (id, name, geopoint)
  VALUES (1, 'Olympia', ST_GeometryFromText('POINT(-122.90 46.97)', 4326));
INSERT INTO geotest (id, name, geopoint)|
  VALUES (2, 'Renton', ST_GeometryFromText('POINT(-122.22 47.50)', 4326));
SELECT name,ST_AsText(geopoint) FROM geotest;