[postgis-users] Migration 0.9 to 1.0 cvs

strk at refractions.net strk at refractions.net
Mon Dec 6 05:37:59 PST 2004

the postgis_restore.pl does not install libraries, simply 
sources the lwpostgis.sql file and *then* restores the dump
removing all functions, aggregates, types operators
and operator classes defined in the .sql file.

postgis_restore.pl output reports its activity using

If you find any 'KEEPING' like with a function,type,etc. which
belongs to postgis this means that postgis_restore.pl was unable
to find a match between objects listed in the dump and objects
defined in the .sql. This can be the case as pg_restore -l output
seems to be changing between postgresql releases. If this happens
you'll be restoring objects of the old installation, which would 
be pointing wherever you made them point at old installation time.

You might want to send me the output of postgis_restore.pl so I can
tell you more.


On Mon, Dec 06, 2004 at 02:31:48PM +0100, Stefano Bonnin wrote:
> Hi,
> I'm updating postgis to 1.0.0 cvs from 0.9 version.
> For this purpose I use the postgis_restore.pl script.
> I have 2 postgres server:
>     the 8.0.0 beta5 with postgis 0.9 (port 5432)
>     and the 8.0.0 RC1 with the postgis-cvs (1.0.0) port 5433
> $ pg_dump -Fc mydb >mydb.dump
> $ postgis_restore.pl lwpostgis.sql myNEWdb mydb.dump 5433
> Now, when I run the script (I have modified it in order to create the new database at the port 5433) I notice that It installs the old 0.9 postgres libraries! but I use the lwpostgis.sql script that comes with the cvs version!
> PS. The old database with Postgis0.9 was created with a postgis.sql script where I replaced the $libdir variable with the absolute path of the 0.9 libraries. Can be this a problem?
> Thanks in advance.
> RedS
> _______________________________________________
> 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