[postgis-users] Small oversights in PostGIS 1.0 RC1 and migration help

[strk at refractions.net]

On Wed, Jan 26, 2005 at 04:51:24PM +0100, Gino Lucrezi wrote:
> I just installed PostgreSQL 8.0 (final version) and PostGIS 1.0 RC1 on a Fedora core 3 system.
> 
> Everything went OK during installation, I just had a few small problems when reimporting existing DBs
> 
> 
> The file utils/postgis_restore.pl doesn't have execute permissions set (easy to fix...)
> 
> The notes inside its comment aren't clear on what one should do with spatial_ref_sys.sql when upgrading.
> 
> The contents in this table have changed considerably. All our old DBs have the 8.1 contents (patched to remove pm=... from 26591 and 26592, as we discussed here a few months ago).
> 
> Obviously, in an existing DB, I can't just drop the table and recreate it according to the newest spatial_ref_sys.sql file, because there are constraints forbidding it; is there any simple way to do it?

Postgis itself does not set constraints to them, you could check if
the new entries from spatial_ref_sys.sql are correct and use
the new ones.
If you added custom ones you should manually back them up in a table
and add them back after new load.

--strk;

> 
> Also, utils/postgis_restore.pl doesn't work well if internationalization variables LANG, LANGUAGE or LC_ALL aren't set correctly; it won't reimport tables which have international characters.
> 
> I'll have to test if reimporting using psql works OK
> 
> 
> Lastly, paragraph 4.3.2 of the PDF documentation has lots of spurious "* 0.60" strings which I suppose arose during the conversion to PDF (they aren't there in the HTML docs)
> 
> 
> Oh, by the way, the search form at http://postgis.refractions.net/support.php doesn't search the mailing list archives anymore!
> 
> 
> Gino Lucrezi
> Penta Consulting Services Srl
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users