<div dir="ltr"><div>so when running my script everything went well except that when i run "psql --version" it still runs the 8.3.2 version... so to do psql (9.2.4) i have to indicate the full path to pgsql9.2.4/bin/psql ..<br>
</div>any idea on how to fix this?<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:07 PM, 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">
The postgis.sql is a part of the restore process. Because you'll
make hard upgrade of PostGIS, you have to use Perl script
<a href="http://postgis_restore.pl" target="_blank">postgis_restore.pl</a>. This script removes old PostGIS functions from
your backup and installs the new ones in the new database. Then, you
have to give the path of postgis.sql (or lwpostgis.sql) when you
call <a href="http://postgis_restore.pl" target="_blank">postgis_restore.pl</a> on command line.<br>
<br>
I'm not really fan of the new procedure using "CREATE EXTENSION
postgis". It's an automatic process enabled in PostgreSQL 9.1 and
more. With this procedure, you have to use PostGIS who is embedded
with PostgreSQL package. I encountered earlier some errors when I
tried to install PostGIS using this procedure on a Windows box. But,
using the old procedure I described above, I had the complete
control of the installation and I always got a functionnal database,
even with PostgreSQL 9.2.<br>
<br>
Regard<br>
<br>
Sylvain Racine<br>
<br>
<br>
<div>Le 2013-07-04 13:06, Marcos Cano a
écrit :<br>
</div><div><div class="h5">
<blockquote type="cite">
<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>
<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" 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>