[postgis-users] migrating from linux to windows

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 <pdoria at netmadeira.com>
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
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





-- 
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081107/cd4b03a1/attachment.html>