[ gpsdrive ] Patches

[Joerg Ostertag (gpsdrive Tettnang/Germany)]

On Samstag 20 Dezember 2008, Sascha Silbe wrote:
> 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.

Thanks for the good description. I adapted
	mapnik-osm-updater.sh
So everyone using this script should now get the spacial extentions configured 
too.

-- 

Joerg