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;