<!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=386343420-04072013><FONT color=#0000ff
size=2 face=Arial>In theory it shouldn't matter, but as far as dumping
goes we usually use the pg_dump that came with the version of PostgreSQL we
are dumping.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=386343420-04072013><FONT color=#0000ff
size=2 face=Arial>So in this case pg_dump for 8.3 to guarantee it dumps
everything allowed to be dumped in that version.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=386343420-04072013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=386343420-04072013><FONT color=#0000ff
size=2 face=Arial>and then restore with the pg_restore that comes with newer
version we are restoring to. In this case
pg_restore packaged with 9.2.4</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=386343420-04072013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=386343420-04072013></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2>N<SPAN class=386343420-04072013>ote
when using postgis_restore.pl make sure the right pg_restore is first
found.</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013>Not sure what platform you are on but FWIW this is how
we do it under windows:</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013><A
href="http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade">http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade</A></SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013>Under Linux/Unix it would be much the same except Perl
is always available so no need for perl install and instead of
using</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013>set you use export , ${...} instead of
%variable% I think. (You probably also want to move the version of PG first in
path if you have multiple installation in your
path)</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013>Hope that helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013>Leo and Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=386343420-04072013></SPAN></FONT></FONT></FONT> </DIV><FONT
color=#0000ff size=2 face=Arial></FONT><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, July 04, 2013 10:08 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] postgres and postgis
upgrade<BR></FONT><BR></DIV>
<DIV></DIV>
<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="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><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 lang=en-us dir=ltr align=left>
<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"
NOSEND="1"></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></BODY></HTML>