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 <[email protected]> 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
punk...@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 --
punk...@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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
