[postgis-users] upgrading from 1.4 to 1.5.1

[Nick Bower]

The docs are a bit rough in this area imo but I think it is assuming  
postgis 1.5 is installed (to libdir/postgis-1.5).

Btw my experience is that it will also assume postgis 1.4 is installed  
to libdir/postgis.  Confusingly when I ran 1.3 to 1.5 I found this and  
that I needed to have both installed to upgrade.

On 20/04/2010, at 4:21 AM, P Kishor <punk.kish at gmail.com> wrote:

> Per the docs at
> <http://www.postgis.org/documentation/manual-1.5/ch02.html#upgrading>,
> I "should find several postgis_upgrade*.sql files." But, it doesn't
> say where I should find them. A little bit of poking around revealed
> the following files to be inside the postgis directory
>
> punkish at Lucknow ~/Projects/postgis-1.5.1$ll postgis
> ..
> -rw-r--r--  1 punkish  punkish  173460 Apr 19 12:51  
> postgis_upgrade_13_to_15.sql
> -rw-r--r--  1 punkish  punkish  173221 Apr 19 12:51  
> postgis_upgrade_14_to_15.sql
> -rw-r--r--  1 punkish  punkish  170268 Apr 19 12:51  
> postgis_upgrade_15_minor.sql
>
> So, I suggest the documentation be corrected to "you should find
> several postgis_upgrade*.sql files in the 'postgis' folder."
>
> Then, I ran the following command, and got errors --
>
> punkish at Lucknow ~/Projects/postgis-1.5.1$psql -f
> postgis/postgis_upgrade_14_to_15.sql -d dbname
> BEGIN
> CREATE FUNCTION
>       postgis_major_version_check
> ------------------------------------------
> Scripts versions checked for upgrade: ok
> (1 row)
>
> DROP FUNCTION
> psql:postgis/postgis_upgrade_14_to_15.sql:49: ERROR:  could not access
> file "$libdir/postgis-1.5": No such file or directory
> psql:postgis/postgis_upgrade_14_to_15.sql:53: ERROR:  current
> transaction is aborted, commands ignored until end of transaction
> block
>
> and so on.
>
> Suggestions?
>
>
> -- 
> Puneet Kishor
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users