<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16618"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>Marcos,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>Short answer. You can't use pg_upgrade to go from 8.3.2 to
9.2.4. In order to use pg_upgrade you need to have the same Minor version
of PostGIS on both installs (e.g 1.3 on both or 1.5 on both or 2.0 on
both)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>So if you are running PostGIS 1.3 on 8.3.2 you can't use
pg_upgrade because PostGIS 1.3 is not supported on 9.2.4. 9.2 requires
PostGIS 2.0+</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>Also going from 1.3 to 2.0 requires a PostGIS hard-upgrade
anyway because the disk formats change and pg_upgrade doesn't do anything with
PostGIS on disk data format.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>We wrote an article about this you might find
useful</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.bostongis.com/blog/index.php?/archives/187-How-to-upgrade-your-database-to-PostGIS-2.0-let-me-count-the-ways.html">http://www.bostongis.com/blog/index.php?/archives/187-How-to-upgrade-your-database-to-PostGIS-2.0-let-me-count-the-ways.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=250595819-20062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Marcos
Cano<BR><B>Sent:</B> Thursday, June 20, 2013 2:54 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Cc:</B>
psql-admin@postgresql.org<BR><B>Subject:</B> [postgis-users] postgis/postgres
upgrade?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr><B>hello im writting to let you know of an issue that i've beem
dealing for more than two weeks. so i just copy the main problem just to put you
in context</B><BR>
<DIV><BR><BR><I>"so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and
following the instructions of the documentation i've found myself in a major
issue which has overwhelmed my little knowledge. <BR>these were the steps i
followed: <BR><BR>1)downloand and install 9.2.4, with the contrib packages.
<BR>2)init the 9.2.4 cluster in /usr/local/pgsql9.2.4/data, i also have the
8.3.2 cluster in /usr/local/pgsql/data <BR>3) stop both servers <BR>4)change the
9.2.4 port to 5433 <BR>5) i run this command:
<BR><BR>/usr/local/pgsql9.2.4/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B
/usr/local/pgsql9.2.4/bin/ -c -d /usr/local/pgsql/data/ -D
/usr/local/pgsql9.2.4/data/ -p 5432 -P 5433 -v <BR><BR><BR>so after some 30
seconds the upgrade process seemed like "working" but after it crashed
<BR>with this message: <BR>Checking for presence of required libraries
fatal <BR><BR>Your installation
references loadable libraries that are missing from the <BR>new installation.
You can add these libraries to the new installation, <BR>or remove the
functions using them from the old installation. A list of <BR>problem
libraries is in the file: <BR> loadable_libraries.txt
<BR><BR>Failure, exiting <BR>"/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D
"/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >>
"pg_upgrade_server.log" 2>&1 <BR><BR><BR>so i went to check the log and
found: <BR><BR><BR>ERROR: could not access file "$libdir/liblwgeom": No
such file or directory <BR>STATEMENT: LOAD '$libdir/liblwgeom'
<BR>command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D
"/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >>
"pg_upgrade_server.log" 2>&1 <BR>LOG: received fast shutdown
request <BR>LOG: aborting any active transactions <BR>waiting for server
to shut down....FATAL: terminating connection due to administrator command
<BR>LOG: could not send data to client: Broken pipe <BR>LOG:
shutting down <BR>LOG: database system is shut down <BR> done
<BR>server stopped <BR><BR><BR>please help as i dont have any idea what's going
wrong"<BR><BR><BR></I><BR></DIV>
<DIV><B>so Robert answered me what i was missing:</B><BR><BR><I>"Means that you
have PostGIS installed and it can't find it in the upgrade path I believe.
Did you get postGI configured correctly in the upgraded version?
"</I><BR><BR><BR></DIV>
<DIV><B>so after looking and thinking i came up withe these question which is my
main concern:</B><BR><BR><BR><BR><I>i'm a little bit confused right now and i
really need some help.. this is my case: <BR>i have pg8.3.2 running with postgis
1.3.x, i'm willing to upgrade to pg9.2.4 using the pg_upgrade utility, now the
problem is that apparently i need to upgrade also to postgis 2.0.3 (so that's
two upgrades in one) i read the instruction in postgis webpage and i need to do
a hard_upgrade... which is a dump and restore. <BR><BR>so i don't know how to
proceed... install pg9.2.4 -> upgrade pg8.3.2 to pg 9.2.4-> then
postgis??? or <BR><BR>install pg9.2.4->install postgis 2.0.3 in the pg9.2.4
-> (pg_upgrade of the DB on pg8.3 to 9.2.4) OR hard_upgrade using the
postgis scripts? <BR><BR>thanks <BR><BR></I></DIV>
<DIV><B> so Robert came up with this intuitive and helpful
answer:<BR></B><I>Marcos, <BR>This answer might be best put over on the postGIS
listserv, but I will suggest a couple of strategies based on some differing
assumptions and certainties. <BR><BR>One certainty - it seems that you
absolutely have to have some form of PostGIS installed in order to perform the
postgreSQL upgrade using pg_upgrade. <BR>One variable - whether or not you will
have to do the "hard upgrade" required by the postGIS version when doing the
standard PostgreSQL upgrade. In other words -- is the postgreSQL upgrade
essentially doing the same as the "hard upgrade"? <BR> If YES - then
install postgis 1.3.x on your 9.2.4 then use pg_upgrade, then do the pgis hard
upgrade <BR> If NO - install postgis 2.x on your 9.2.4 then use
pg_upgrade <BR><BR>This is a very relevant case study, one that I myself will be
going through very very shortly here so I am interested to follow your progress
and assist in whatever way I might. </I><BR><BR></DIV>
<DIV><BR></DIV><B>But really i'm really stuck right now can you please give me
some guidance on what to do next? thank you very much</B></DIV></BODY></HTML>