<div dir="ltr">Thanks for your input. I tried that approach and it did not work. It gave the same results when I go the "short" way around by create extensions. Afterwards I tried with Postgres 8.4, going "the long way". The same results.<div>
Specifically:</div><div>[snipped lots of messages like ERROR: syntax error at or near "'<div> UPDATE '"</div><div>LINE 1: EXECUTE '</div><div>]</div><div><br></div><div>then eventually: </div>
<div><br></div><div><div>CREATE FUNCTION pygeocode(text) RETURNS character varying</div><div> LANGUAGE plpythonu</div><div> AS $_$"</div><div>LINE 1: $_$;</div><div> ^</div><div>ERROR: syntax error at or near "#"</div>
<div>LINE 1: # This retrieves the URL from Google,</div><div> ^</div><div>invalid command \n</div><div>out of memory</div></div><div><br></div><div>(out of memory happens after a while)</div><div><br></div><div>Any tips or ideas are more than welcome. The perl script has not been tested with postGIS version 1.3.6 - anyone had any success with that particular version?</div>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Sep 6, 2013 at 5:59 PM, Marcos Cano <span dir="ltr"><<a href="mailto:mcano@stsa.info" target="_blank">mcano@stsa.info</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I did that a few months ago... Basically what I did was..<div><br></div><div><br></div><div>Install pg9.2.4 (latest stable version) with disable-integer-datetimes</div>
<div><br></div><div>And postgis 2.0.3 pointing against this Postgres version with : --with-pgconfig= thepath/to/pg9.2.4/bin/pg_config</div>
<div><br></div><div>I run the both servers the newest in a different tcp port because there were something's I still need from</div><div>That server.</div><div><br></div><div>Do a pg_dump of the postgis enabled database.. I did the pg_dump with the /bin/ folder of</div>
<div>The older version.</div><div><br></div><div><br></div><div>In the new server I created a spatially enabled database make sure you make it the long way (without EXTENSIONS)</div><div><br></div><div>Then I did a restore with the perl script </div>
<div><br></div><div>Greetings <span></span></div><div><div><div class="h5"><br>On Friday, September 6, 2013, Athanasios Kostopoulos wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Dear list,</span><div style="font-family:arial,sans-serif;font-size:13px">I have a problem that proves to be quite the brain-teaser (at least for me).</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">I have an ancient database (8.4.X) integrated with postGIS 1.3.6. Clearly, this while currently working will reach end of life soon and needs to be upgraded.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">On a Debian wheezy system, I installed postgres 9.2/postgis2.0 - all from the apt repositories provided by postgres. When I try to do things the recommended way from postGIS (processing the backup with the perl script) during restore I get a few errors and constantly increasing memory usage, until the restore process will die with an "out of memory error". When I try to restore the "pure" dump, I get a number of errors.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Now, I understand that I am talking a big increase in major versions, including some non backwards compatible changes in postgis but such an upgrade should be feasible. Can someone give me a small push, so I can move forward with this? I would prefer to upgrade to the latest versions of postgresql and postGIS, if such a thing is possible.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Thanks in advance for any replies.</div></div>
<br>
</div></div><p><font>classmarkets GmbH | Schumannstraße 6 | 10117 Berlin | Deutschland<br>Tel: <a href="tel:%2B49%20%280%2930%2056%2059%20001-0" value="+493056590010" target="_blank">+49 (0)30 56 59 001-0</a> | Fax: <a href="tel:%2B49%20%280%2930%2056%2059%20001-99" value="+4930565900199" target="_blank">+49 (0)30 56 59 001-99</a> | <a href="http://www.classmarkets.com" target="_blank">www.classmarkets.com</a></font></p>
<p><font>Amtsgericht Charlottenburg HRB 111815 B | <a href="http://USt.Id.Nr" target="_blank">USt.Id.Nr</a>: DE 260731582<br>Geschäftsführer: Veit Mürz, Fabian Ströhle</font></p>
<p><font>Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sie darf ausschließlich durch den vorgesehenen Empfänger und Adressaten gelesen, kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon unverzüglich zu informieren und die Nachricht zu löschen. Jede unerlaubte Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollständig oder teilweise, ist unzulässig. Bitte beachten Sie, dass E-Mail-Nachrichten an den Absender nicht für fristgebundene Mitteilungen geeignet sind. Fristgebundene Mitteilungen sind daher ausschließlich per Post oder per Telefax zu übersenden.</font></p>
</blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>
<br>
<p><font size="2">classmarkets GmbH | Schumannstraße 6 | 10117 Berlin | Deutschland<br>Tel: +49 (0)30 56 59 001-0 | Fax: +49 (0)30 56 59 001-99 | <a href="http://www.classmarkets.com" target="_blank">www.classmarkets.com</a></font></p><p><font size="2">Amtsgericht Charlottenburg HRB 111815 B | <a href="http://USt.Id.Nr" target="_blank">USt.Id.Nr</a>: DE 260731582<br>Geschäftsführer: Veit Mürz, Fabian Ströhle</font></p>
<p><font size="2">Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sie darf ausschließlich durch den vorgesehenen Empfänger und Adressaten gelesen, kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon unverzüglich zu informieren und die Nachricht zu löschen. Jede unerlaubte Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollständig oder teilweise, ist unzulässig. Bitte beachten Sie, dass E-Mail-Nachrichten an den Absender nicht für fristgebundene Mitteilungen geeignet sind. Fristgebundene Mitteilungen sind daher ausschließlich per Post oder per Telefax zu übersenden.</font></p>