From 4f4d77790441a7f0c972e1ff4d832e42a116a279 Mon Sep 17 00:00:00 2001 From: Chris Hodgson Date: Wed, 17 Jul 2002 18:34:10 +0000 Subject: [PATCH] added a "common problems" sub-section to the "installing postgis" section git-svn-id: http://svn.osgeo.org/postgis/trunk@174 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/postgis.xml | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) diff --git a/doc/postgis.xml b/doc/postgis.xml index 8b92b8ca9..aa46fc59d 100644 --- a/doc/postgis.xml +++ b/doc/postgis.xml @@ -143,7 +143,20 @@ new postgis.sql file, then upload your database dump:UPDATE TABLE <table> SET <geocolumn> = SetSRID(<geocolumn>,<SRID>); +substitutions:UPDATE TABLE <table> SET <geocolumn> = SetSRID(<geocolumn>,<SRID>); + Common Problems + There are several things to check when your installation or upgrade doesn't go as you expected. + + It is easiest if you untar the PostGIS distribution into the contrib directory under the PostgreSQL source tree. However, if this is not possible for some reason, you can set the PGSQL_SRCenvironment variable to the path to the PostgreSQL source directory. This will allow you to compile PostGIS, but the make install may not work, so be prepared to copy the PostGIS library and executable files to the appropriate locations yourself. + Check that you you have installed PostgreSQL 7.1 or newer, and that you are compiling against the same version of the PostgreSQL source as the version of PostgreSQL that is running. Mix-ups can occur when your (Linux) distrubution has already installed PostgreSQL, or you have otherwise installed PostgreSQL before and forgotten about it. PostGIS will only work with PostgreSQL 7.1 or newer, and strange, unexpected error messages will result if you use an older version. To check the version of PostgreSQL which is running, connect to the database using psql and run this query:SELECT version(); + + Also check that you have made any necessary changes to the top of the Makefile. This includes: + + Changing the USE_PG72=0line to USE_PG72=1 if you are using PostgreSQL 7.2 or newer. If this line is incorrect, it will result in a large number of errors being generated when executing the sql statements in the postgis.sql file. + Also, if you want to be able to do coordinate reprojections, you must install the Proj.4 library on your system, and set the USE_PROJ variable to 1 in the Makefile. + + + JDBC The JDBC extensions provide Java objects corresponding to the -- 2.40.0