[
https://issues.apache.org/jira/browse/HAWQ-799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15323834#comment-15323834
]
ASF GitHub Bot commented on HAWQ-799:
-------------------------------------
Github user kdunn926 commented on the issue:
https://github.com/apache/incubator-hawq/pull/700
@xunzhang - Below is the build and test process I've used within
[this](https://s3.amazonaws.com/hdbonhdp/HDB-Sandbox-2.0-vmware-2016060805245816.zip)
sandbox:
Please see [this](https://github.com/greenplum-db/postgis/pull/1) PR for
the majority of the HAWQ-specific code changes relative to that PostGIS branch.
```
# PostGIS build dependencies
yum install gdal gdal-devel geos geos-devel proj proj-devel libxml2-devel
byacc bison libxslt ImageMagick -y
git clone ...
cd incubator-hawq/contrib/postgis
# Make sure residual objects are gone
for o in o so a la ; do find ./ -type f -name *.${o} | xargs -exec rm ;
done ;
make distclean
# Some build-time requirements
export CFLAGS="-I/usr/local/hawq-2.0.0.0/include
-I/usr/local/hawq-2.0.0.0/include/postgresql/server"
export CXXFLAGS=${CFLAGS}
export PG_CFLAGS=${CFLAGS}
export PG_CPPFLAGS=${CFLAGS}
export LD_LIBRARY_PATH=/lib64:/usr/lib64:/usr/local/hawq-2.0.0.0/lib
./configure --prefix=/temp --with-pgconfig=/usr/local/hawq/bin/pg_config
# This is a build-time work-around for the stale references to
# /opt/gcc-4.4.2/bin/gcc provided by HAWQ's pg_config output
sudo mkdir -p /opt/gcc-4.4.2/bin
cd /opt/gcc-4.4.2/bin
sudo ln -s /usr/bin/gcc gcc
make -j9
sudo make install
export PGPORT=10432
cd extras/ogc_test_suite
make
file contents of RPM in the PostGIS GPPKG:
/temp
/temp/bin
/temp/bin/pgsql2shp
/temp/bin/shp2pgsql
/temp/include
/temp/include/liblwgeom.h
/temp/lib
/temp/lib/liblwgeom-2.0.3.so
/temp/lib/liblwgeom.a
/temp/lib/liblwgeom.la
/temp/lib/liblwgeom.so
/temp/lib/postgresql
/temp/lib/postgresql/postgis-2.0.so
/temp/share
/temp/share/postgresql
/temp/share/postgresql/contrib
/temp/share/postgresql/contrib/postgis-2.0
/temp/share/postgresql/contrib/postgis-2.0/legacy.sql
/temp/share/postgresql/contrib/postgis-2.0/legacy_gist.sql
/temp/share/postgresql/contrib/postgis-2.0/legacy_minimal.sql
/temp/share/postgresql/contrib/postgis-2.0/postgis.sql
/temp/share/postgresql/contrib/postgis-2.0/postgis_comments.sql
/temp/share/postgresql/contrib/postgis-2.0/postgis_restore.pl
/temp/share/postgresql/contrib/postgis-2.0/postgis_upgrade_20_minor.sql
/temp/share/postgresql/contrib/postgis-2.0/raster_comments.sql
/temp/share/postgresql/contrib/postgis-2.0/spatial_ref_sys.sql
/temp/share/postgresql/contrib/postgis-2.0/topology.sql
/temp/share/postgresql/contrib/postgis-2.0/topology_comments.sql
/temp/share/postgresql/contrib/postgis-2.0/topology_upgrade_20_minor.sql
/temp/share/postgresql/contrib/postgis-2.0/uninstall_legacy.sql
/temp/share/postgresql/contrib/postgis-2.0/uninstall_postgis.sql
/temp/share/postgresql/contrib/postgis-2.0/uninstall_topology.sql
```
> PostGIS Support
> ---------------
>
> Key: HAWQ-799
> URL: https://issues.apache.org/jira/browse/HAWQ-799
> Project: Apache HAWQ
> Issue Type: Wish
> Reporter: Kyle R Dunn
> Assignee: Lei Chang
>
> Would be great to have some basic PostGIS support in HAWQ.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
