<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6001.18148" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>Willy,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>Hmm good question. I suppose we should put that
in the manual.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>I think in old versions of PostGIS, the .so, .dll was
hard-coded. Is that the problem you are running into?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>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</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>with no .pl or anything. Then running
probe_geometry_columns to restore geometry_columns.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>Anyrate it sounds like that's the path you are leading
down though mine is admittedly more lazy and sloppy.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=102512806-07112008>Hope
that helps,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=102512806-07112008>Regina</SPAN></FONT></DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Willy-Bas Loos<BR><B>Sent:</B> Thursday, November 06, 2008 11:45
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users]
migrating from linux to windows<BR></FONT><BR></DIV>
<DIV></DIV>Hi Pedro,<BR><BR>Ok, i know dblink. I could do some replace(..) on
the library file locations, but that seems pretty hairy..<BR>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.<BR>Otherwise i could try to modify the resulting SQL to not to drop
the geometry type for example.<BR><BR>I'll give it a shot and report back.
<BR>WHY IS THIS NOT IN THE MANUAL??<BR>I guess that could have something to do
with finances etc.. :(<BR><BR>cheers,<BR><BR>WBL<BR><BR>
<DIV class=gmail_quote>On Thu, Nov 6, 2008 at 5:04 PM, Pedro Doria Meunier <SPAN
dir=ltr><<A
href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi
Willy<BR><BR>If everything else fails you might turn to db_link
...<BR><BR>Willy-Bas Loos wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c>Hi,<BR><BR>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)<BR><BR>what's the correct way to go about that?<BR>Will the perl script
postgis_restore.pl work?<BR>I'm trying it out, but i am encountering some
problems that might not be related.<BR><BR>So would it work in theory or is
there a better way?<BR><BR>thx<BR><BR>WBL<BR>-- <BR>"Patriotism is the
conviction that your country is superior to all others because you were born
in it." -- George Bernard
Shaw<BR></DIV></DIV>------------------------------------------------------------------------<BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR> <BR></BLOCKQUOTE>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>"Patriotism is the conviction that your country is superior
to all others because you were born in it." -- George Bernard
Shaw<BR></BODY></HTML>