diff options
author | Edwin Groothuis <edwin@FreeBSD.org> | 2005-12-28 21:10:57 +0000 |
---|---|---|
committer | Edwin Groothuis <edwin@FreeBSD.org> | 2005-12-28 21:10:57 +0000 |
commit | 0e4f2cc24d8b7af2d01c4e3b35b615714d0b2e99 (patch) | |
tree | ba2ebc1b5bac698e88a98358d1a596153ebccff4 /databases/postgis/files | |
parent | Add p5-WebService-NoPaste 0.03, a pastebin web application to upload (diff) |
[maintainer-update] Postgis upgrade from 1.0.6 to 1.1.0
Postgis upgrade from 1.0.6 to 1.1.0 .
This release, includes new functionality, performance
improvements and bug fixes. Highlights include:
* Geometry building functions, including line merging, polygon creation and vertex manipulation,
* Linear referencing functions, including support for measures,
* Performance improvements to coordinate reference transformations
PR: ports/91030
Submitted by: Anderson S. Ferreira <anderson@cnpm.embrapa.br>
Diffstat (limited to 'databases/postgis/files')
-rw-r--r-- | databases/postgis/files/README.postgis | 214 | ||||
-rw-r--r-- | databases/postgis/files/patch-GNUmakefile | 30 | ||||
-rw-r--r-- | databases/postgis/files/patch-configure | 10 | ||||
-rw-r--r-- | databases/postgis/files/patch-doc | 53 | ||||
-rw-r--r-- | databases/postgis/files/patch-loader | 31 | ||||
-rw-r--r-- | databases/postgis/files/patch-lwgeom | 46 | ||||
-rw-r--r-- | databases/postgis/files/patch-main | 31 | ||||
-rw-r--r-- | databases/postgis/files/patch-utils | 23 |
8 files changed, 80 insertions, 358 deletions
diff --git a/databases/postgis/files/README.postgis b/databases/postgis/files/README.postgis deleted file mode 100644 index 12163a476453..000000000000 --- a/databases/postgis/files/README.postgis +++ /dev/null @@ -1,214 +0,0 @@ -PostGIS - Geographic Information Systems Extensions to PostgreSQL -~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - -VERSION: 1.0.0 (2005/01/13) - -MORE INFORMATION: http://postgis.refractions.net - -INTRODUCTION: -This distribution contains a module which implements GIS simple -features, ties the features to rtree indexing, and provides some -spatial functions for accessing and analyzing geographic data. - -Directory structure: - - ./ Build scripts and install directions. - ./lwgeom Library source code. - ./jdbc Extensions to the PostgreSQL JDBC drivers to support - the GIS objects. - ./doc Documentation on the code, objects and functions - provided. - ./loader A program to convert ESRI Shape files into SQL text - suitable for uploading into a PostGIS/PostgreSQL database - and a program for converting PostGIS spatial tables into - Shape files.. - ./examples Small programs which demonstrate ways of accessing - GIS data. - - -INSTALLATION: - -PostGIS is compatible with PostgreSQL 7.2 and above. - -To install the module, move this directory to the "contrib" directory of your -PostgreSQL source installation. Alternately, point PGSQL_SRC at your -PostgreSQL source tree either in an environment variable or editing -Makefile.config. - -You *must* have a PostgreSQL source tree, and you *must* have succesfully -built and installed it for this to work. - -SEE THE NOTE ON GEOS SUPPORT BELOW FOR SPECIAL COMPILATION INSTRUCTIONS - - -* PROJ4 SUPPORT (Recommended): - The Proj4 reprojection library is required if you want to use the - transform() function to reproject features within the database. - - http://www.remotesensing.org/proj - - Install Proj4 in the default location. - Edit the postgis Makefile.config and change the USE_PROJ variable to 1 - and ensure that the PROJ_DIR variable points to your Proj4 - installation location (/usr/local is the default). - -* SPATIAL PREDICATE / GEOS SUPPORT (Recommended): - The GEOS library provides support for exact topological tests - such as Touches(), Contains(), Disjoint() and spatial operations - such as Intersection(), Union() and Buffer(). - - http://geos.refractions.net - - In order to use the GEOS support, you *may* need to specially compile - your version of PostgreSQL to link the C++ runtime library. - To do this, invoke the PgSQL configuration script this way: - - LDFLAGS=-lstdc++ ./configure --your-options-go-here - - The initial LDFLAGS variable is passed through to the Makefile and - adds the C++ library to the linking stage. - Once you have compiled PgSQL with C++ support, you can enable GEOS - support in PostGIS by setting the USE_GEOS variable in the PostGIS - Makefile.config to 1, and ensure that the GEOS_DIR variable points - to your GEOS installation location (/usr/local is the default). - - -To compile PostGIS, as root run: - - make - make install - -PostGIS now requires the PL/pgSQL procedural language in order to operate -correctly. To install PL/pgSQL use the 'createlang' program from the PostgreSQL -installation. (The PostgreSQL Programmer's Guide has details if you want -to this manually for some reason.) - -As postgres run: - - createlang plpgsql yourdatabase - psql -f lwpostgis.sql -d yourdatabase - -Installation should now be complete. - - -UPGRADING: - -Upgrading PostGIS can be tricky, because the underlying C libraries which -support the object types and geometries may have changed between versions. - -For this purpose PostGIS provides an utility script to restore a dump -produced with the pg_dump -Fc command. It is experimental so redirecting -its output to a file will help in case of problems. The procedure is -as follow: - - # Create a "custom-format" dump of the database you want - # to upgrade (let's call it "olddb") - $ pg_dump -Fc olddb olddb.dump - - # Restore the dump contextually upgrading postgis into - # a new database. The new database doesn't have to exist. - # Let's call it "newdb" - $ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump > restore.log - - # Check that all restored dump objects really had to be restored from dump - # and do not conflict with the ones defined in lwpostgis.sql - $ grep ^KEEPING restore.log | less - - # If upgrading from PostgreSQL < 7.5 to >= 7.5 you might want to - # drop the attrelid, varattnum and stats columns in the geometry_columns - # table, which are no-more needed. Keeping them won't hurt. - # !!! DROPPING THEM WHEN REALLY NEEDED WILL DO HURT !!!! - $ psql newdb -c "ALTER TABLE geometry_columns DROP attrelid" - $ psql newdb -c "ALTER TABLE geometry_columns DROP varattnum" - $ psql newdb -c "ALTER TABLE geometry_columns DROP stats" - - # spatial_ref_sys table is restore from the dump, to ensure your custom - # additions are kept, but the distributed one might contain modification - # so you should backup your entries, drop the table and source the new one. - # If you did make additions we assume you know how to backup them before - # upgrading the table. Replace of it with the new one is done like this: - $ psql newdb - newdb=> drop table spatial_ref_sys; - DROP - newdb=> \i spatial_ref_sys.sql - -Following is the "old" procedure description. IT SHOULD BE AVOIDED if possible, -as it will leave in the database many spurious functions. It is kept in this document -as a "backup" in case postgis_restore.pl won't work for you: - - pg_dump -t "*" -f dumpfile.sql yourdatabase - dropdb yourdatabase - createdb yourdatabase - createlang plpgsql yourdatabase - psql -f lwpostgis.sql -d yourdatabase - psql -f dumpfile.sql -d yourdatabase - vacuumdb -z yourdatabase - - -USAGE: - -Try the following example SQL statements to create non-OpenGIS tables and -geometries: - - CREATE TABLE geom_test ( gid int4, geom geometry,name varchar(25) ); - INSERT INTO geom_test ( gid, geom, name ) - VALUES ( 1, 'POLYGON((0 0 0,0 5 0,5 5 0,5 0 0,0 0 0))', '3D Square'); - INSERT INTO geom_test ( gid, geom, name ) - VALUES ( 2, 'LINESTRING(1 1 1,5 5 5,7 7 5)', '3D Line' ); - INSERT INTO geom_test ( gid, geom, name ) - VALUES ( 3, 'MULTIPOINT(3 4,8 9)', '2D Aggregate Point' ); - SELECT * from geom_test WHERE geom && 'BOX3D(2 2 0,3 3 0)'::box3d; - -The following SQL creates proper OpenGIS entries in the SPATIAL_REF_SYS -and GEOMETRY_COLUMNS tables, and ensures that all geometries are created -with an SRID. - - INSERT INTO SPATIAL_REF_SYS - ( SRID, AUTH_NAME, AUTH_SRID, SRTEXT ) VALUES - ( 1, 'EPSG', 4269, - 'GEOGCS["NAD83", - DATUM[ - "North_American_Datum_1983", - SPHEROID[ - "GRS 1980", - 6378137, - 298.257222101 - ] - ], - PRIMEM["Greenwich",0], - UNIT["degree",0.0174532925199433]]' - ); - - CREATE TABLE geotest ( - id INT4, - name VARCHAR(32) - ); - - SELECT AddGeometryColumn('db','geotest','geopoint',1,'POINT',2); - - INSERT INTO geotest (id, name, geopoint) - VALUES (1, 'Olympia', GeometryFromText('POINT(-122.90 46.97)',1)); - INSERT INTO geotest (id, name, geopoint) - VALUES (2, 'Renton', GeometryFromText('POINT(-122.22 47.50)',1)); - - SELECT name,AsText(geopoint) FROM geotest; - - -Spatial Indexes: - -PostgreSQL provides support for GiST spatial indexing. The GiST scheme offers -indexing even on large objects, using a system of "lossy" indexing where -a large object is proxied by a smaller one in the index. In the case -of the PostGIS indexing system, all objects are proxied in the index by -their bounding boxes. - -You can build a GiST index with: - - CREATE INDEX <indexname> - ON <tablename> - USING GIST ( <geometryfield> ); - -Always run the "VACUUM ANALYZE <tablename>" on your tables after -creating an index. This gathers statistics which the query planner -uses to optimize index usage. - diff --git a/databases/postgis/files/patch-GNUmakefile b/databases/postgis/files/patch-GNUmakefile new file mode 100644 index 000000000000..e2125b8c00e0 --- /dev/null +++ b/databases/postgis/files/patch-GNUmakefile @@ -0,0 +1,30 @@ +--- GNUmakefile Mon Dec 19 18:23:23 2005 ++++ GNUmakefile Wed Dec 28 15:38:36 2005 +@@ -4,9 +4,15 @@ + # + #----------------------------------------------------- + +-all: Makefile.config liblwgeom loaderdumper utils ++all: Makefile.config liblwgeom loaderdumper utils ++ifneq ($(WITH-DOC),) ++ $(MAKE) -C doc ++endif + +-install: all liblwgeom-install loaderdumper-install ++install: all liblwgeom-install loaderdumper-install utils-install ++ifneq ($(WITH-DOC),) ++ $(MAKE) -C doc install ++endif + + uninstall: liblwgeom-uninstall loaderdumper-uninstall docs-uninstall + +@@ -74,6 +80,9 @@ + + utils: + $(MAKE) -C utils ++ ++utils-install: ++ $(MAKE) -C utils install + + configure: configure.in + ./autogen.sh diff --git a/databases/postgis/files/patch-configure b/databases/postgis/files/patch-configure new file mode 100644 index 000000000000..c6a745d0706c --- /dev/null +++ b/databases/postgis/files/patch-configure @@ -0,0 +1,10 @@ +--- configure Wed Dec 21 20:25:14 2005 ++++ configure Wed Dec 28 13:57:10 2005 +@@ -4050,6 +4050,7 @@ + /usr/share/sgml/docbook/xsl-stylesheets + /usr/share/xml/docbook/stylesheet/nwalsh + /usr/share/sgml/docbook/stylesheet/xsl/nwalsh ++ /usr/local/share/xsl/docbook + " + for p in ${SEARCHPATH}; do + if test -r ${p}/html/docbook.xsl; then diff --git a/databases/postgis/files/patch-doc b/databases/postgis/files/patch-doc deleted file mode 100644 index 17606bc0e664..000000000000 --- a/databases/postgis/files/patch-doc +++ /dev/null @@ -1,53 +0,0 @@ ---- doc/Makefile Tue Apr 12 08:17:04 2005 -+++ doc/Makefile Fri Dec 9 23:36:05 2005 -@@ -1,11 +1,14 @@ - COMMONOPTS = -f docbook -b html -e no-valid - -+include ../Makefile.config -+include $(top_srcdir)/src/Makefile.shlib -+ - # fetch version numbers from central repository - include ../Version.config - - LAST_RELEASE_VERSION = $(SO_MAJOR_VERSION).$(SO_MINOR_VERSION).$(SO_MICRO_VERSION) - --XSLBASE?=/usr/share/sgml/docbook/xsl-stylesheets -+XSLBASE?=/usr/local/share/xsl/docbook - #XSLBASE = /usr/share/xml/docbook/stylesheet/nwalsh - - all: html -@@ -16,14 +19,13 @@ - chunked-html: postgis-out.xml - xsltproc \ - --output html/ \ -- --param shade.verbatim 1 \ - --param chunk.section.depth 0 \ - --param section.autolabel 1 \ - --param section.label.includes.component.label 1 \ - --stringparam html.stylesheet style.css \ - --stringparam saxon.character.representation decimal \ - $(XSLBASE)/html/chunk.xsl \ -- $< -+ $< && touch chunked-html - - html/postgis.html: postgis-out.xml - xsltproc \ -@@ -67,6 +69,16 @@ - maintainer-clean: clean - @rm -f html/*.html - --install: html/postgis.html man/shp2pgsql.1 man/pgsql2shp.1 -- -+install: chunked-html -+ $(mkinstalldirs) $(DOCSDIR) -+ $(INSTALL_DATA) html/index.html $(DOCSDIR)/index.html -+ $(INSTALL_DATA) html/ch01.html $(DOCSDIR)/ch01.html -+ $(INSTALL_DATA) html/ch02.html $(DOCSDIR)/ch02.html -+ $(INSTALL_DATA) html/ch03.html $(DOCSDIR)/ch03.html -+ $(INSTALL_DATA) html/ch04.html $(DOCSDIR)/ch04.html -+ $(INSTALL_DATA) html/ch05.html $(DOCSDIR)/ch05.html -+ $(INSTALL_DATA) html/ch06.html $(DOCSDIR)/ch06.html -+ $(INSTALL_DATA) html/ch07.html $(DOCSDIR)/ch07.html -+ $(INSTALL_DATA) html/apa.html $(DOCSDIR)/apa.html -+ - .PHONY: html diff --git a/databases/postgis/files/patch-loader b/databases/postgis/files/patch-loader index 4578f090a97d..df0665377b5d 100644 --- a/databases/postgis/files/patch-loader +++ b/databases/postgis/files/patch-loader @@ -1,13 +1,22 @@ ---- loader/Makefile Wed Jan 12 15:03:57 2005 -+++ loader/Makefile Mon Jan 31 14:36:59 2005 -@@ -31,8 +32,8 @@ - $(CC) $(CFLAGS) $(OBJS) shp2pgsql.o $(LDFLAGS) -o $@ +--- loader/Makefile Fri Dec 16 14:47:24 2005 ++++ loader/Makefile Wed Dec 28 14:23:13 2005 +@@ -9,7 +9,7 @@ + #--------------------------------------------------------------- - install: all -- $(INSTALL_PROGRAM) pgsql2shp$(EXE) $(DESTDIR)$(bindir)/pgsql2shp$(EXE) -- $(INSTALL_PROGRAM) shp2pgsql$(EXE) $(DESTDIR)$(bindir)/shp2pgsql$(EXE) -+ $(INSTALL_PROGRAM) pgsql2shp$(EXE) $(DESTDIR)$(BINDIR)/pgsql2shp$(EXE) -+ $(INSTALL_PROGRAM) shp2pgsql$(EXE) $(DESTDIR)$(BINDIR)/shp2pgsql$(EXE) + ifeq ($(USE_ICONV),1) +- override CFLAGS += -DUSE_ICONV ++ override CFLAGS += -DUSE_ICONV -I/usr/local/include + override LDFLAGS += $(ICONV_LDFLAGS) + endif + +--- loader/shp2pgsql.c Tue Nov 1 07:25:47 2005 ++++ loader/shp2pgsql.c Wed Dec 28 14:23:13 2005 +@@ -33,7 +33,7 @@ + #include <unistd.h> + #include <errno.h> + #include "getopt.h" +-#ifdef HAVE_ICONV_H ++#ifdef USE_ICONV + #include <iconv.h> + #endif - uninstall: - rm -f $(DESTDIR)$(bindir)/pgsql2shp$(EXE) diff --git a/databases/postgis/files/patch-lwgeom b/databases/postgis/files/patch-lwgeom index 4d32f7bc90c6..f582e2ea0094 100644 --- a/databases/postgis/files/patch-lwgeom +++ b/databases/postgis/files/patch-lwgeom @@ -1,41 +1,11 @@ ---- lwgeom/Makefile Mon Apr 4 06:48:57 2005 -+++ lwgeom/Makefile Thu Apr 21 17:08:37 2005 -@@ -21,10 +21,10 @@ +--- lwgeom/Makefile Wed Dec 28 17:39:49 2005 ++++ lwgeom/Makefile Wed Dec 28 17:41:22 2005 +@@ -128,7 +128,7 @@ + $(PERL) ../utils/postgis_proc_upgrade.pl ../lwpostgis.sql > ../lwpostgis_upgrade.sql - ifeq (${USE_VERSION},71) - MODULE_FILENAME = $(LPATH)/$(shlib) -- MODULE_INSTALLDIR = $(libdir) -+ MODULE_INSTALLDIR = $(LIBDIR) - else - MODULE_FILENAME = $(LPATH)/$(shlib) -- MODULE_INSTALLDIR = $(pkglibdir) -+ MODULE_INSTALLDIR = $(LIBDIR) - endif + ../lwpostgis.sql: lwpostgis.sql.in +- cpp -P -traditional-cpp -DUSE_VERSION=$(USE_VERSION) $< | sed -e 's:@MODULE_FILENAME@:$(MODULE_FILENAME):g;s:@POSTGIS_VERSION@:$(POSTGIS_VERSION):g;s:@POSTGIS_SCRIPTS_VERSION@:$(SCRIPTS_VERSION):g;s/@POSTGIS_BUILD_DATE@/$(POSTGIS_BUILD_DATE)/g' | grep -v '^#' > $@ ++ cpp -P -traditional-cpp -DUSE_VERSION=$(USE_VERSION) $< | sed -e 's:@MODULE_FILENAME@:$$libdir/liblwgeom.so.1:g;s:@POSTGIS_VERSION@:$(POSTGIS_VERSION):g;s:@POSTGIS_SCRIPTS_VERSION@:$(SCRIPTS_VERSION):g;s/@POSTGIS_BUILD_DATE@/$(POSTGIS_BUILD_DATE)/g' | grep -v '^#' > $@ - #--------------------------------------------------------------- -@@ -143,9 +143,9 @@ - install: all installdirs install-lwgeom-lib install-lwgeom-scripts + install: all install-lib-shared install-lwgeom-scripts - install-lwgeom-scripts: -- $(INSTALL_DATA) lwpostgis.sql $(DESTDIR)$(datadir)/contrib/lwpostgis.sql -- $(INSTALL_DATA) ../spatial_ref_sys.sql $(DESTDIR)$(datadir)/contrib/spatial_ref_sys.sql -- $(INSTALL_DATA) ../README.postgis $(DESTDIR)$(docdir)/contrib/README.postgis -+ $(INSTALL_DATA) lwpostgis.sql $(DESTDIR)$(DATADIR)/lwpostgis.sql -+ $(INSTALL_DATA) ../spatial_ref_sys.sql $(DESTDIR)$(DATADIR)/spatial_ref_sys.sql -+ $(INSTALL_DATA) ../README.postgis $(DESTDIR)$(DATADIR)/README.postgis - $(INSTALL_DATA) ../doc/man/pgsql2shp.1 $(DESTDIR)$(mandir)/man1/pgsql2shp.1 - $(INSTALL_DATA) ../doc/man/shp2pgsql.1 $(DESTDIR)$(mandir)/man1/shp2pgsql.1 - -@@ -171,9 +171,9 @@ - sh ../geos_version.sh $(GEOS_DIR) > postgis_geos_version.h - - installdirs: -- $(mkinstalldirs) $(DESTDIR)$(MODULE_INSTALLDIR) -- $(mkinstalldirs) $(DESTDIR)$(datadir)/contrib -- $(mkinstalldirs) $(DESTDIR)$(docdir)/contrib -+ $(mkinstalldirs) $(LIBDIR) -+ $(mkinstalldirs) $(DATADIR) -+ $(mkinstalldirs) $(DOCSDIR) - - uninstall-lwgeom-scripts: - rm -f $(DESTDIR)$(datadir)/contrib/lwpostgis.sql diff --git a/databases/postgis/files/patch-main b/databases/postgis/files/patch-main deleted file mode 100644 index bb69bbd559c9..000000000000 --- a/databases/postgis/files/patch-main +++ /dev/null @@ -1,31 +0,0 @@ ---- Makefile Tue Mar 8 13:46:23 2005 -+++ Makefile Mon Mar 28 09:22:32 2005 -@@ -5,8 +5,15 @@ - #----------------------------------------------------- - - all: liblwgeom loaderdumper utils -+ifneq ($(WITH-DOC),) -+ $(MAKE) -C doc chunked-html -+endif - - install: all liblwgeom-install loaderdumper-install -+ $(MAKE) INSTALL_DATA="$(INSTALL_DATA)" DATADIR=$(DATADIR) -C utils install -+ifneq ($(WITH-DOC),) -+ $(MAKE) INSTALL_DATA="$(INSTALL_DATA)" DOCSDIR=$(DOCSDIR) -C doc install -+endif - - uninstall: liblwgeom-uninstall loaderdumper-uninstall - ---- Makefile.config Thu Dec 1 07:26:49 2005 -+++ Makefile.config Fri Dec 9 23:27:18 2005 -@@ -75,8 +75,8 @@ - # Use ICONV_LDFLAGS and ICONV_CFLAGS to fine-tune usage. - # - USE_ICONV ?= 0 --ICONV_CFLAGS ?= --ICONV_LDFLAGS ?= -+ICONV_CFLAGS ?=-I/usr/local/include -+ICONV_LDFLAGS ?=-L/usr/local/lib -liconv - - # - # Path to library (to be specified in CREATE FUNCTION queries) diff --git a/databases/postgis/files/patch-utils b/databases/postgis/files/patch-utils index 0d3ad32ec52b..9a948addfbb5 100644 --- a/databases/postgis/files/patch-utils +++ b/databases/postgis/files/patch-utils @@ -1,21 +1,22 @@ ---- utils/Makefile Tue Mar 8 09:11:29 2005 -+++ utils/Makefile Mon Mar 28 09:45:41 2005 +--- utils/Makefile Mon Jun 6 13:49:41 2005 ++++ utils/Makefile Wed Dec 28 15:33:31 2005 @@ -1,3 +1,6 @@ +include ../Makefile.config -+include $(top_srcdir)/src/Makefile.shlib ++include ../Version.config + SCRIPTS = \ postgis_restore.pl \ - profile_intersects.pl \ -@@ -6,3 +9,11 @@ + create_undef.pl \ +@@ -8,3 +11,12 @@ all: chmod +x $(SCRIPTS) + +install: -+ $(mkinstalldirs) $(DATADIR)/utils -+ $(INSTALL_DATA) README $(DATADIR)/utils/README -+ $(INSTALL_DATA) postgis_restore.pl $(DATADIR)/utils/postgis_restore.pl -+ $(INSTALL_DATA) profile_intersects.pl $(DATADIR)/utils/profile_intersects.pl -+ $(INSTALL_DATA) test_estimation.pl $(DATADIR)/utils/test_estimation.pl -+ $(INSTALL_DATA) test_joinestimation.pl $(DATADIR)/utils/test_joinestimation.pl ++ @mkdir -p $(DESTDIR)$(datadir)/utils ++ $(INSTALL_DATA) README $(DESTDIR)$(datadir)/utils/README ++ $(INSTALL_DATA) create_undef.pl $(DESTDIR)$(datadir)/utils/create_undef.pl ++ $(INSTALL_DATA) postgis_restore.pl $(DESTDIR)$(datadir)/utils/postgis_restore.pl ++ $(INSTALL_DATA) profile_intersects.pl $(DESTDIR)$(datadir)/utils/profile_intersects.pl ++ $(INSTALL_DATA) test_estimation.pl $(DESTDIR)$(datadir)/utils/test_estimation.pl ++ $(INSTALL_DATA) test_joinestimation.pl $(DESTDIR)$(datadir)/utils/test_joinestimation.pl |