[ gpsdrive ] Patches

[Sascha Silbe]

On Sat, Dec 20, 2008 at 12:46:56PM +0100, Guenther Meyer wrote:

> right, the spatial_ref_sys table is empty.
Sounds like the database wasn't properly PostGIS-enabled. The last three 
steps of the PostGIS installation instructions (to be repeated for each 
database that should be PostGIS-enabled):

  5. PostGIS requires the PL/pgSQL procedural language extension. Before 
loading the lwpostgis.sql file, you must first
     enable PL/pgSQL. You should use the createlang command. The 
PostgreSQL Programmer's Guide has the details if you want
     to this manually for some reason.

     # createlang plpgsql [yourdatabase]

  6. Now load the PostGIS object and function definitions into your 
database by loading the lwpostgis.sql definitions file.

     # psql -d [yourdatabase] -f lwpostgis.sql

     The PostGIS server extensions are now loaded and ready to use.

  7. For a complete set of EPSG coordinate system definition 
identifiers, you can also load the spatial_ref_sys.sql
     definitions file and populate the SPATIAL_REF_SYS table.

     # psql -d [yourdatabase] -f spatial_ref_sys.sql


The last step populates the spatial_ref_sys table. The mentioned SQL 
files are in /usr/share/postgresql-8.3-postgis on my (Debian) system.

CU Sascha

-- 
http://sascha.silbe.org/
http://www.infra-silbe.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 481 bytes
Desc: Digital signature
URL: <http://lists.gpsdrivers.org/pipermail/gpsdrive/attachments/20081220/1c1f62af/attachment.bin>