[postgis-users] postgresql8.0 and postgis1.0.0

[Obe, Regina DND\MIS]

The short answer is that you leave out all the postgis function calls in
your dump, create a new database and load the postgis functions using the
new scripts. Then you just load the data.  

I didn't find an easy way to selectively load tables and views using the
.sql format (and I actually didn't want to bring over some old junky tables
I had) so I opted for the dumping using .tar format.  Not sure if this is
the easiest way, but this is what I did.

1) Make sure you have the new postgis installed and have run the lwgeom,
spatial_ref.sql files in your new db

2) I used the new pg_dump util (from 8.0 to dump the old db) - I'm not sure
what happens if you use the old one.  Anyrate the general command was

pg_dump -h myoldpgserver -n public -F t myolddb -f mydata.tar

(you might need to change the above a bit if you are backing up from a
non-local pc that does not have a trust relationship with your old server)

3) pg_restore --list mydata.tar > restoreitems.txt 
(this gives you a list of the items backuped up - which you can then edit to
only restore the stuff you want) 

4)Edit the restoreitems.txt - cutting out all references to postgis
functions and any other stuff you don't want to restore

5) pg_restore --use-list=restoreitems.txt --dbname=mynewdb
--username=postgres mydata.tar
(here I was on the real server so had no need for the -h flag)

-----Original Message-----
From: Pritesh Shah [mailto:pritesh.krish at gmail.com] 
Sent: Wednesday, February 16, 2005 4:09 AM
To: pgsql-general at postgresql.org; postgis-users at postgis.refractions.net
Subject: [postgis-users] postgresql8.0 and postgis1.0.0


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