<div dir="ltr">well i guess while installing and making the postgis i installed it against the 9.2.4 (with this : "./configure --with-pgconfig=/usr/local/pgsql9.2.4/bin/pg_config" )<br><div><br>the postgis.sql you mention is to create a spatially enabled database? or is it part of the restore process?<br>
<br></div><div>and yes im using the full path to the command to do everything.<br><br></div><div>thank you very much i really appreciate it<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 9:51 AM, Racine, Sylvain <span dir="ltr"><<a href="mailto:syracine@sympatico.ca" target="_blank">syracine@sympatico.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
You have to use pg_dump version 8.3.2 to backup your database,e.g.
the same version of your source database. To restore, use the Perl
script and postgis.sql given with Postgis 2.0.4. This script calls
pg_dump command. It must be pg_dump version 9.2.4, e.g. your
destination database version. Use "pg_dump --version" to know the
version of your command.<br>
<br>
You seem use 2 differents versions of PostgreSQL and PostGIS on the
same computer. To get a particular version of a command, type the
whole path of the command.<br>
<br>
Regard<br>
<br>
Sylvain Racine<br>
<br>
<div>Le 2013-07-04 10:07, Marcos Cano a
écrit :<br>
</div><div><div class="h5">
<blockquote type="cite">
<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">
<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>
<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></div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<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>
</pre>
</blockquote>
<br>
</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>