Date: Thu, 12 Sep 2013 11:07:50 GMT From: Trevor Caira <trevor@bitba.se> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/182032: [new port] databases/postgis21: Adds support for geographic objects to PostgreSQL databases Message-ID: <201309121107.r8CB7oNR095611@oldred.freebsd.org> Resent-Message-ID: <201309121110.r8CBA0cq050050@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 182032 >Category: ports >Synopsis: [new port] databases/postgis21: Adds support for geographic objects to PostgreSQL databases >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu Sep 12 11:10:00 UTC 2013 >Closed-Date: >Last-Modified: >Originator: Trevor Caira >Release: FreeBSD 9.2-RC3 >Organization: Bitbase LLC >Environment: System: FreeBSD tour 9.2-RC3 FreeBSD 9.2-RC3 #0 r254795: Sat Aug 24 20:25:04 UTC 2013 root@bake.isc.freebsd.org:/usr/obj/usr/src/sys/GENERIC amd64 >Description: New port: databases/postgis21 Adds support for geographic objects to PostgreSQL databases. This port updates (and conflicts with) the postgis* line of ports. Postgis 2.1.0 introduces new features, performance improvements and bug fixes. New functions are detailed at [0]. [0] http://postgis.net/docs/manual-2.1/PostGIS_Special_Functions_Index.html#NewFunctions_2_1 >How-To-Repeat: >Fix: A shar containing the new port is attached. Patch attached with submission follows: # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # postgis21 # postgis21/pkg-install # postgis21/Makefile # postgis21/distinfo # postgis21/pkg-plist # postgis21/pkg-descr # echo c - postgis21 mkdir -p postgis21 > /dev/null 2>&1 echo x - postgis21/pkg-install sed 's/^X//' >postgis21/pkg-install << '121427a73f46e7cb5ff327c41d986143' X#!/bin/sh X Xmsg(){ X echo " X ======================= GEOS Support Notice ======================== X In order to use the GEOS support, you may need to specially compile X your version of PostgreSQL to link the C++ runtime library. X To do this, invoke the PostgreSQL Makefile script this way: X X on csh shell: X X setenv LDFLAGS -lstdc++ X make X X on sh or bash shell: X X export LDFLAGS=-lstdc++ X make X X The initial LDFLAGS variable is passed through to the Makefile and X adds the C++ library to the linking stage. X X ==================================================================== X" Xif [ -n "${PACKAGE_BUILDING}" ]; then X sleep 10 Xfi X X X} X Xcase "$2" in X PRE-INSTALL) X msg ;; X MESSAGE) X msg ;; Xesac 121427a73f46e7cb5ff327c41d986143 echo x - postgis21/Makefile sed 's/^X//' >postgis21/Makefile << 'bb1fcbde207136fbbe5ae73cf04e0eb5' X# $FreeBSD$ X XPORTNAME= postgis XPORTVERSION= 2.1.0 XCATEGORIES= databases geography XMASTER_SITES= http://download.osgeo.org/postgis/source/ X XMAINTAINER= trevor@bitba.se XCOMMENT= Adds support for geographic objects to PostgreSQL databases X XLIB_DEPENDS= proj:${PORTSDIR}/graphics/proj \ X geos:${PORTSDIR}/graphics/geos \ X json:${PORTSDIR}/devel/json-c XRUN_DEPENDS= postmaster:${PORTSDIR}/databases/postgresql${PGSQL_VER}-server X XCONFLICTS= postgis-1.* postgis-2.0.* XLATEST_LINK= postgis21 X XUSE_GNOME= libxml2 XUSE_PGSQL= yes XUSE_GMAKE= yes XUSES= iconv XUSE_LDCONFIG= yes XGNU_CONFIGURE= yes XUSE_PERL5_BUILD= yes X XOPTIONS_DEFINE= LOADERGUI RASTER TOPOLOGY XOPTIONS_DEFAULT= TOPOLOGY X XPLIST_SUB+= PORTVERSION=${PORTVERSION} X XLOADERGUI_DESC= Enable shp2pgsql-gui XRASTER_DESC= Build with raster support XTOPOLOGY_DESC= Build with topology support X X.include <bsd.port.options.mk> X X.if ${PORT_OPTIONS:MLOADERGUI} XUSE_GNOME+= gtk20 XCONFIGURE_ARGS+= --with-gui XPLIST_SUB+= LOADERGUI="" X.else XCONFIGURE_ARGS+= --without-gui XPLIST_SUB+= LOADERGUI="@comment " X.endif X X.if ${PORT_OPTIONS:MRASTER} X.if ${OSVERSION} < 900033 XBROKEN= Raster suppport is broken on FreeBSD < 9.x X.endif XLIB_DEPENDS+= gdal:${PORTSDIR}/graphics/gdal XCONFIGURE_ARGS+= --with-raster --with-gdalconfig=${LOCALBASE}/bin/gdal-config XPLIST_SUB+= RASTER="" X.else XCONFIGURE_ARGS+= --without-raster XPLIST_SUB+= RASTER="@comment " X.endif X X.if ${PORT_OPTIONS:MTOPOLOGY} XCONFIGURE_ARGS+= --with-topology XPLIST_SUB+= TOPOLOGY="" X.else XCONFIGURE_ARGS+= --without-topology XPLIST_SUB+= TOPOLOGY="@comment " X.endif X XCFLAGS+= -I${LOCALBASE}/include XLDFLAGS+= -L${LOCALBASE}/lib X Xpost-patch: X @${GREP} -lR 'bin/bash' ${WRKSRC} | ${XARGS} ${REINPLACE_CMD} -e "s|/bin/bash|/bin/sh|" X Xpre-configure: X @${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL X Xpost-install: .SILENT X ${MKDIR} ${DATADIR}/tiger_2011 X (cd ${WRKSRC}/extras/tiger_geocoder/tiger_2011/ && ${COPYTREE_SHARE} \* ${DATADIR}/tiger_2011/ "! ( -name *\.orig -o -name *\.bak )" ) X ${MKDIR} ${DATADIR}/utils X (cd ${WRKSRC}/utils/ && ${COPYTREE_SHARE} \* ${DATADIR}/utils/ "! ( -name *\.orig -o -name *\.bak )" ) X X.include <bsd.port.mk> bb1fcbde207136fbbe5ae73cf04e0eb5 echo x - postgis21/distinfo sed 's/^X//' >postgis21/distinfo << '5692aa43a46d507f5481dd33029fe3d5' XSHA256 (postgis-2.1.0.tar.gz) = fc00481aec904661f3eb11da4305b1666f2040c28b0651de7eac6c22f217b26c XSIZE (postgis-2.1.0.tar.gz) = 6518378 5692aa43a46d507f5481dd33029fe3d5 echo x - postgis21/pkg-plist sed 's/^X//' >postgis21/pkg-plist << 'd5eaca68fbfb9166e71f76fe41a0d844' Xbin/pgsql2shp X%%RASTER%%bin/raster2pgsql Xbin/shp2pgsql X%%LOADERGUI%%bin/shp2pgsql-gui Xinclude/liblwgeom.h Xlib/postgresql/postgis-2.1.so X%%RASTER%%lib/postgresql/rtpostgis-2.1.so Xlib/liblwgeom-%%PORTVERSION%%.so Xlib/liblwgeom.a Xlib/liblwgeom.la Xlib/liblwgeom.so X%%DATADIR%%/tiger_2011/README X%%DATADIR%%/tiger_2011/census_loader.sql X%%DATADIR%%/tiger_2011/create_geocode.bat X%%DATADIR%%/tiger_2011/create_geocode.sh X%%DATADIR%%/tiger_2011/create_geocode.sql X%%DATADIR%%/tiger_2011/geocode/census_tracts_functions.sql X%%DATADIR%%/tiger_2011/geocode/geocode.sql X%%DATADIR%%/tiger_2011/geocode/geocode_address.sql X%%DATADIR%%/tiger_2011/geocode/geocode_intersection.sql X%%DATADIR%%/tiger_2011/geocode/geocode_location.sql X%%DATADIR%%/tiger_2011/geocode/includes_address.sql X%%DATADIR%%/tiger_2011/geocode/interpolate_from_address.sql X%%DATADIR%%/tiger_2011/geocode/other_helper_functions.sql X%%DATADIR%%/tiger_2011/geocode/rate_attributes.sql X%%DATADIR%%/tiger_2011/geocode/reverse_geocode.sql X%%DATADIR%%/tiger_2011/geocode_settings.sql X%%DATADIR%%/tiger_2011/legacy_import/tiger2008/import_tiger_shps.sh X%%DATADIR%%/tiger_2011/normalize/count_words.sql X%%DATADIR%%/tiger_2011/normalize/end_soundex.sql X%%DATADIR%%/tiger_2011/normalize/get_last_words.sql X%%DATADIR%%/tiger_2011/normalize/location_extract.sql X%%DATADIR%%/tiger_2011/normalize/location_extract_countysub_exact.sql X%%DATADIR%%/tiger_2011/normalize/location_extract_countysub_fuzzy.sql X%%DATADIR%%/tiger_2011/normalize/location_extract_place_exact.sql X%%DATADIR%%/tiger_2011/normalize/location_extract_place_fuzzy.sql X%%DATADIR%%/tiger_2011/normalize/normalize_address.sql X%%DATADIR%%/tiger_2011/normalize/pprint_addy.sql X%%DATADIR%%/tiger_2011/normalize/state_extract.sql X%%DATADIR%%/tiger_2011/pagc_normalize/pagc_normalize_address.sql X%%DATADIR%%/tiger_2011/pagc_normalize/pagc_tables.sql X%%DATADIR%%/tiger_2011/regress/geocode_regress X%%DATADIR%%/tiger_2011/regress/geocode_regress.sql X%%DATADIR%%/tiger_2011/regress/normalize_address_regress X%%DATADIR%%/tiger_2011/regress/normalize_address_regress.sql X%%DATADIR%%/tiger_2011/regress/pagc_normalize_address_regress.sql X%%DATADIR%%/tiger_2011/regress/regress.sql X%%DATADIR%%/tiger_2011/regress/reverse_geocode_regress X%%DATADIR%%/tiger_2011/regress/reverse_geocode_regress.sql X%%DATADIR%%/tiger_2011/tables/lookup_tables_2011.sql X%%DATADIR%%/tiger_2011/tiger_loader_2011.sql X%%DATADIR%%/tiger_2011/tiger_loader_2012.sql X%%DATADIR%%/tiger_2011/topology/README X%%DATADIR%%/tiger_2011/topology/tiger_topology_loader.sql X%%DATADIR%%/tiger_2011/upgrade_geocode.sql X%%DATADIR%%/tiger_2011/upgrade_geocoder.bat X%%DATADIR%%/tiger_2011/upgrade_geocoder.sh X%%DATADIR%%/tiger_2011/utility/cull_null.sql X%%DATADIR%%/tiger_2011/utility/levenshtein_ignore_case.sql X%%DATADIR%%/tiger_2011/utility/nullable_levenshtein.sql X%%DATADIR%%/tiger_2011/utility/set_search_path.sql X%%DATADIR%%/tiger_2011/utility/utmzone.sql X%%DATADIR%%/utils/Makefile X%%DATADIR%%/utils/Makefile.in X%%DATADIR%%/utils/README X%%DATADIR%%/utils/create_undef.pl X%%DATADIR%%/utils/postgis_proc_upgrade.pl X%%DATADIR%%/utils/postgis_restore.pl X%%DATADIR%%/utils/postgis_restore.pl.in X%%DATADIR%%/utils/profile_intersects.pl X%%DATADIR%%/utils/read_scripts_version.pl X%%DATADIR%%/utils/svn_repo_revision.pl X%%DATADIR%%/utils/test_estimation.pl X%%DATADIR%%/utils/test_geography_estimation.pl X%%DATADIR%%/utils/test_geography_joinestimation.pl X%%DATADIR%%/utils/test_joinestimation.pl X%%DATADIR%%/utils/uninstall_script Xshare/postgresql/contrib/postgis-2.1/legacy.sql Xshare/postgresql/contrib/postgis-2.1/legacy_gist.sql Xshare/postgresql/contrib/postgis-2.1/legacy_minimal.sql Xshare/postgresql/contrib/postgis-2.1/postgis.sql Xshare/postgresql/contrib/postgis-2.1/postgis_comments.sql Xshare/postgresql/contrib/postgis-2.1/postgis_restore.pl Xshare/postgresql/contrib/postgis-2.1/postgis_upgrade_20_21.sql Xshare/postgresql/contrib/postgis-2.1/postgis_upgrade_21_minor.sql Xshare/postgresql/contrib/postgis-2.1/raster_comments.sql Xshare/postgresql/contrib/postgis-2.1/spatial_ref_sys.sql Xshare/postgresql/contrib/postgis-2.1/uninstall_legacy.sql Xshare/postgresql/contrib/postgis-2.1/uninstall_postgis.sql Xshare/postgresql/contrib/postgis-2.1/uninstall_sfcgal.sql X%%RASTER%%share/postgresql/contrib/postgis-2.1/rtpostgis.sql X%%RASTER%%share/postgresql/contrib/postgis-2.1/rtpostgis_legacy.sql X%%RASTER%%share/postgresql/contrib/postgis-2.1/rtpostgis_upgrade_20_21.sql X%%RASTER%%share/postgresql/contrib/postgis-2.1/rtpostgis_upgrade_21_minor.sql X%%RASTER%%share/postgresql/contrib/postgis-2.1/uninstall_rtpostgis.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/contrib/postgis-2.1/topology.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/contrib/postgis-2.1/topology_upgrade_21_minor.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/contrib/postgis-2.1/uninstall_topology.sql X%%TOPOLOGY%%share/postgresql/contrib/postgis-2.1/topology_comments.sql X%%RASTER%%share/postgresql/extension/postgis--2.0.0--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.0.1--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.0.2--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.0.3--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.0.4--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--%%PORTVERSION%%--%%PORTVERSION%%next.sql X%%RASTER%%share/postgresql/extension/postgis--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--%%PORTVERSION%%next--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.1.0rc1--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.1.0rc2--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--2.1.0rc3--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis--unpackaged--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis.control X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.0.0--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.0.1--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.0.2--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.0.3--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.0.4--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--%%PORTVERSION%%--%%PORTVERSION%%next.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--%%PORTVERSION%%next--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.1.0rc1--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.1.0rc2--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--2.1.0rc3--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder--unpackaged--%%PORTVERSION%%.sql X%%RASTER%%share/postgresql/extension/postgis_tiger_geocoder.control X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.0.0--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.0.1--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.0.2--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.0.3--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.0.4--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--%%PORTVERSION%%--%%PORTVERSION%%next.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--%%PORTVERSION%%next--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.1.0rc1--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.1.0rc2--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--2.1.0rc3--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology--unpackaged--%%PORTVERSION%%.sql X%%RASTER%%%%TOPOLOGY%%share/postgresql/extension/postgis_topology.control X@dirrm %%DATADIR%%/utils X@dirrm %%DATADIR%%/tiger_2011/utility X@dirrm %%DATADIR%%/tiger_2011/topology X@dirrm %%DATADIR%%/tiger_2011/tables X@dirrm %%DATADIR%%/tiger_2011/regress X@dirrm %%DATADIR%%/tiger_2011/pagc_normalize X@dirrm %%DATADIR%%/tiger_2011/normalize X@dirrm %%DATADIR%%/tiger_2011/legacy_import X@dirrm %%DATADIR%%/tiger_2011/legacy_import/tiger2008 X@dirrm %%DATADIR%%/tiger_2011/geocode X@dirrm %%DATADIR%%/tiger_2011 X@dirrm %%DATADIR%% X@dirrm share/postgresql/contrib/postgis-2.1 d5eaca68fbfb9166e71f76fe41a0d844 echo x - postgis21/pkg-descr sed 's/^X//' >postgis21/pkg-descr << '7de8957fb083cb3332477082f6b121df' XPostGIS adds support for geographic objects to the PostgreSQL object-relational Xdatabase. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing Xit to be used as a backend spatial database for geographic information systems X(GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the XOpenGIS "Simple Features Specification for SQL" and has been certified as Xcompliant with the "Types and Functions" profile. X XPostGIS development was started by Refractions Research as a project in open Xsource spatial database technology. PostGIS is released under the GNU General XPublic License. PostGIS continues to be developed by a group of contributors led Xby a Project Steering Committee and new features continue to be added. X XWWW: http://www.postgis.org/ 7de8957fb083cb3332477082f6b121df exit >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201309121107.r8CB7oNR095611>