[postgis-users] Migration 0.9 to 1.0 cvs
Stefano Bonnin
stefano.bonnin at comai.to
Mon Dec 6 05:57:37 PST 2004
Sorry, I commised again the same error of this morning.
The postgis_restore.pl use run all commands with a relative path (without
./) and it ran a wrong createlang version command present in /usr/bin.
Sorry again.
Thanks
Reds
----- Original Message -----
From: <strk at refractions.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, December 06, 2004 2:37 PM
Subject: Re: [postgis-users] Migration 0.9 to 1.0 cvs
> Stefano,
> 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
> KEEPING FUNCTION|TYPE|... <object>
> and
> SKIPPING FUNCTION|TYPE|.... <object>
>
> 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.
>
> --strk;
>
> 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
>
> _______________________________________________
> 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