[postgis-users] upgrading Guide with problem

Peter Padua Krauss ppkrauss at gmail.com
Wed Dec 21 06:09:49 PST 2011


Hello,

I have a lot of problems with ch.2.7.1 at

http://www.postgis.org/docs/ch02.html#upgrading

------
1) postgis_upgrade_13_to_15.sql  NOT EXIST

    The links not have any file.

        locate postgis_upgrade_13_to_15.sql
        not exist

    for downlaod ONLY with google, searching with "filetype:sql
postgis_upgrade_13_to_15.sql"
    we have only one download,


http://mapserver.sara.nl/scratch/pgsql843/share/contrib/postgis-1.5/postgis_upgrade_13_to_15.sql

   PS: http://svn.osgeo.org/postgis/trunk/postgis/
              not have the file.

2)  problem with the ch.2.7.1 recomendation,
   $ psql -f postgis_upgrade_13_to_15.sql -d your_spatial_database
psql: FATAL: role "root" not exist


3) try to create only a important function,

CREATE OR REPLACE FUNCTION _ST_AsGeoJson(int4, geometry, int4, int4)

	RETURNS TEXT
	AS '$libdir/postgis-1.5','LWGEOM_asGeoJson'
	LANGUAGE 'C' IMMUTABLE STRICT;

-- file "$libdir/postgis-1.5" NOT EXIST


4) ...


----
CLUES,

select postgis_lib_version();
 1.3.3


My installation have things like
   /usr/share/doc/postgresql-8.3-postgis
   and
   /usr/share/java/postgis.jar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111221/94e20d34/attachment.html>


More information about the postgis-users mailing list