[postgis-users] hard upgrade

[S Racine]

How far I can remember, I don't think that postgis_restore.pl create geometry_columns table. This table is created when you run lwpostgis.sql (or simply postgis.sql) into a regular PostgreSQL database (populated with data or not). Don't forget to run also spatial_ref_sys.sql too in your database.

After restoring your data by postgis_restore.pl, you can populate your geometry_columns table by running 'SELECT populate_geometry_columns()' in any SQL editor. (I don't know if that command was there in PostGIS 1.4, but it is there in my PostGIS 1.5)

Sylvain Racine

> Date: Fri, 10 Feb 2012 17:28:20 +0100
> From: strk at keybit.net
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] hard upgrade
> 
> On Fri, Feb 10, 2012 at 11:19:53AM -0500, Stephen Crawford wrote:
> 
> > I'm doing an update from postgres 7.1 / postGIS 1.2  to 8.4 / 1.4.
> 
> Brave !
> 
> > I'm doing a dump and restore using postgis_restore.pl.  The
> > geometry_columns table doesn't get restored.  Any ideas?
> 
> Do you have a log file to show ?
> 
> --strk; 
> 
>   ,------o-. 
>   |   __/  |    Delivering high quality PostGIS 2.0 !
>   |  / 2.0 |    http://strk.keybit.net
>   `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120213/21ca7caf/attachment.html>