hi,
I would like to thank everybody for their responses to my question. I
tried a couple of things and the best thing for me was to use
utils/postgis_restore.pl script.
I ran this script on some sample databases and they all seemed to
work, but partially, as there are still some errors.
These errors are because some postgis content is not being stripped
out while writing into the $dump.list file. A sample of where it fails
is:
....
....
....
CREATE FUNCTION wkb_recv(internal) RETURNS wkb
AS '$libdir/libpostgis.so.0.8', 'WKB_recv'
LANGUAGE c STRICT;
ERROR: could not access file "$libdir/libpostgis.so.0.8": No such file or direc
tory
ALTER FUNCTION public.wkb_recv(internal) OWNER TO brook;
ERROR: function public.wkb_recv(internal) does not exist
...
...
...
This line should be stripped out as in the new postgis (1.0.0) there
is nothing called "WKB_recv" which existed in the older version
(0.8.2)
There are many such cases where the postgis_restore.pl script fails in
removing the postgis stuff. I'm currently working on getting this
fixed.
Cheers,
Pritesh
On Wed, Feb 16, 2005 at 02:09:11AM -0700, Pritesh Shah wrote:
> hi,
>
> I'm trying to backup a server and restore it on a different machine
> with newer versions of postgresql and postgis. Dumps have been created
> for the following versions from the old database server:
>
> Postgresql 7.4.6
> Postgis 0.8.2
>
> Now since both the packages have released newer versions i've
> installed the following on my newer machine where i would like to
> restore the dumped databases.
>
> Postgresql 8.0.1 and
> Postgis 1.0.0
>
> For restoring the information i'm using
>
> psql -e -f abc.sql template1
>
> While restoring the dumps i've collected the following information
> where the problem occurs:
>
> ..
> ..
> ..
> CREATE FUNCTION histogram2d_in(cstring) RETURNS histogram2d
> AS '$libdir/libpostgis.so.0.8', 'histogram2d_in'
> LANGUAGE c STRICT;
> psql:abc.sql:3947: ERROR: could not access file
> "$libdir/libpostgis.so.0.8": No such file or directory
> ..
> ..
> ..
>
> I understand that this is due to the following:
>
> libpostgis.so.8.0 is now liblwgeom.so.1.0 and also
>
> histogram2d_in is now lwhistogram2d_in
> histogram2d_out is now lwhistogram2d_out and so on.
>
> Now my problem is there are a lot of databases that use the postgis
> stuff (like the histogram2d_in) which has changed from the older
> version to the newer version. What do i do to overcome this problem??
> Can somebody help me out with this??
>
> Cheers,
> Pritesh
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
