[postgis-users] Re: Upgrade 1.2.1 to 1.3.1 - Problems

Per-Olof Norén pelle at alma.nu
Thu Oct 18 16:27:15 PDT 2007

Hi again,

You said earlier that you had run the upgrade.sql. I take this is from 
the 1.3.1 distros upgrade script?

The "meet" of postgis is essentially a new datatype (geometry) and a 
bunch of function that operate on geometries.
Almost all of them calls libwgeom, which i think wraps either geos or 
proj4 library for most calls.
I upgraded my postgis to 1.2.1 two months ago by issuing a make install.
After that I dumped my db:s to file using pg_dump and dropped them from 
the running system and ran lwpostgis.sql and spatial_ref_sys.sql using 
the psql client.
This is what I think is generally  called a "hard upgrade".

So, if you havent done it, I recomend either test create a db and run 
above scripts to install postgis into it.
If that works, then dump/drop/restore your proper database.

With this said, I'm running ubuntu and basically gets everything served 
by the package maintainer, so practise on upgrades etc seldom happens.

Maybe som of the more hardcore devs listens here, and can give further 


Brian Hamlin skrev:
> so.. continuing on... all that Make install does is..
>    rm -f theOldLib
>    ln newlib oldLib
> I did that by hand.. but, Postgres still looks for the old file..
> Postgres has to be informed of the new lib somehow..
> this has not come up for anyone?
> bug submission process??
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list