Willy, Hmm good question. I suppose we should put that in the manual. I think in old versions of PostGIS, the .so, .dll was hard-coded. Is that the problem you are running into? I haven't tried this with old versions recently (or at least can't remember off-hand), but I think I've been successful just creating a new database from scratch, loading the latest postgis functions in it and then restoring on top of that with no .pl or anything. Then running probe_geometry_columns to restore geometry_columns. It leaves some junk but as I remember I think that worked for me and I think the dump just then throws some errors because it can't restore the hardcoded functions but manages to load the data since the dependency functions already exist in the database. Anyrate it sounds like that's the path you are leading down though mine is admittedly more lazy and sloppy. Hope that helps, Regina
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Willy-Bas Loos Sent: Thursday, November 06, 2008 11:45 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] migrating from linux to windows Hi Pedro, Ok, i know dblink. I could do some replace(..) on the library file locations, but that seems pretty hairy.. Maybe it would be easyer to use create_undef.pl and then just load a dump of the undeffed db into a freshly created database with postgis, i just hope that my geometry data will not be lost. Otherwise i could try to modify the resulting SQL to not to drop the geometry type for example. I'll give it a shot and report back. WHY IS THIS NOT IN THE MANUAL?? I guess that could have something to do with finances etc.. :( cheers, WBL On Thu, Nov 6, 2008 at 5:04 PM, Pedro Doria Meunier <[EMAIL PROTECTED]> wrote: Hi Willy If everything else fails you might turn to db_link ... Willy-Bas Loos wrote: Hi, I want to migrate a postgis database from postgis 1.1.6 on debian to 1.3.3 on windows. (i know, i like linux better too) what's the correct way to go about that? Will the perl script postgis_restore.pl work? I'm trying it out, but i am encountering some problems that might not be related. So would it work in theory or is there a better way? thx WBL -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw ------------------------------------------------------------------------ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users -- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
