<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Sorry for the delay. It was the week end. So I closed the computer.
To disable psql command for 8.3.2 version, you have to remove the
whole path of your old PostgreSQL installation from you PATH
variable and replace it by the new one. Depending of the type of OS
you use, ex. on Linux, type "echo PATH" to see the paths associated
to your system or on Windows, type just "PATH" to see the paths.<br>
<br>
If you need any help to remove the PostgreSQL 8.3.2 version from
PATH variable, please indicate the type of OS you use.<br>
<br>
Regard<br>
<br>
Sylvain Racine<br>
<br>
<div class="moz-cite-prefix">Le 2013-07-05 11:41, Marcos Cano a
écrit :<br>
</div>
<blockquote
cite="mid:CAP2RsaJ3Re+sqyuhS9p5=wDDRpYBzmeVvDv6Xi0NHqL0wu-UxQ@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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
moz-do-not-send="true" 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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org"
target="_blank">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>