<div dir="ltr">what version of pg_dump should i use?... i tried the 8..3.2 and i think it works, but trying the suggested one, wich is the latest (9.2.4) seems just to not work properly because it does not dump my entire database (i assume is because of the mismatch of postgis versions)<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 3, 2013 at 12:00 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Yes (custom dump of 8.3.2 + pgis, create new postgis 2.0.4 in
9.2.4 and restore backup) is the recommended way. 9.2.4 + 1.5.8 are
borderline compatible so I would avoid that mix and if your ultimate goal is to
go to 2.0, 1.5.8 requires a hard upgrade anyway so not worth the
hassle.</font></span></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Marcos
Cano<br><b>Sent:</b> Wednesday, July 03, 2013 10:43 AM<br><b>To:</b>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] postgres and
postgis upgrade<br></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr">So I'm trying to upgrade Postgres and postgis.. My current versions
are 8.3.2 and 1.3 respectively. And trying to upgrade to postgis 2.0.4 and
Postgres 9.2.4
<div><br></div>
<div>I've been trying a lot of options like:hard upgrade of postgis to
1.5.8 in the Postgres 8.3 ( as I'm sure that version of postgis is
compatible with Postgres 8.3 and 9.2.4)</div>
<div>Then installing postgres 9.2.4 + postgis 1.5.8 and do a pg_upgrade and
finally do a hard upgrade of postgis to 2.0.4 in the postgres 9.2.4
installation. It seems to work until an error happened during the
pg_upgrade<br><br>Your installation contains the "name" data type in user
tables. This data type changed its internal alignment between your old and
new clusters so this cluster cannot currently be upgraded. You can
remove the problem tables and restart the upgrade.<br></div>
<div><br></div>
<div>So I tried another option but I don't know if this will work. Here's my
idea:</div>
<div><br></div>
<div><br></div>
<div><br></div>
<div>Do a custom dump of the DB in Postgres 8.3.2 + pgis 1.3 .</div>
<div><br></div>
<div>Install 9.2.4 with postgis 2.0.4</div>
<div>And do a restore with perl script included in the postgis binary
folder (perl utils/<a href="http://postgis_restore.pl" target="_blank">postgis_restore.pl</a>)<br></div>
<div><br></div>do you think it will work?<br>
<div>
<div>
<div><img src="http://images/cleardot.gif"></div></div></div></div></div></div></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>
<br></blockquote></div><br></div>