<!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 bgColor=#ffffff text=#000000>
<DIV dir=ltr align=left><SPAN class=048471401-26062013><FONT color=#0000ff
size=2 face=Arial>Use these links instead. Old site links are
not being updated anymore</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=048471401-26062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=048471401-26062013><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/docs/manual-2.0/postgis_installation.html#hard_upgrade">http://postgis.net/docs/manual-2.0/postgis_installation.html#hard_upgrade</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=048471401-26062013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=048471401-26062013><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net/documentation">http://postgis.net/documentation</A></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>Alain
Benard<BR><B>Sent:</B> Tuesday, June 25, 2013 11:20 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] RE :
Trying to restore a .backup file<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR>i think the problem is with a backup / restore from an old
postgis version to a new postgis version. The postgis function are differents
between 2 version and you cannot juste restore the database even if you don't
install the extension (the definition of the old functions are not in the
executable file from the new installation). In the Postgis documentation you can
find a perl tools wich analyze a backup file and delete what can be in conflict
before process the pg_restore. The chapter '<SMALL>2.9.2. Hard
upgrade</SMALL>' in the folowwing page is probably the solution
:<BR> <A
href="http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade">http://www.postgis.org/documentation/manual-svn/postgis_installation.html#hard_upgrade</A><BR>have
a nice day.<BR>Alain. </BODY></HTML>