[postgis-users] upgrading from 1.4 to 1.5.1

[P Kishor]

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