<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
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.<br><br>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)<br><br>Sylvain Racine<br><br><div><div id="SkyDrivePlaceholder"></div>> Date: Fri, 10 Feb 2012 17:28:20 +0100<br>> From: strk@keybit.net<br>> To: postgis-users@postgis.refractions.net<br>> Subject: Re: [postgis-users] hard upgrade<br>> <br>> On Fri, Feb 10, 2012 at 11:19:53AM -0500, Stephen Crawford wrote:<br>> <br>> > I'm doing an update from postgres 7.1 / postGIS 1.2 to 8.4 / 1.4.<br>> <br>> Brave !<br>> <br>> > I'm doing a dump and restore using postgis_restore.pl. The<br>> > geometry_columns table doesn't get restored. Any ideas?<br>> <br>> Do you have a log file to show ?<br>> <br>> --strk; <br>> <br>> ,------o-. <br>> | __/ | Delivering high quality PostGIS 2.0 !<br>> | / 2.0 | http://strk.keybit.net<br>> `-o------'<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div> </div></body>
</html>