[postgis-users] RE : Trying to restore a .backup file

[Paragon Corporation]

Use these links instead.  Old site links are not being updated anymore
 
http://postgis.net/docs/manual-2.0/postgis_installation.html#hard_upgrade
 
http://postgis.net/documentation

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Alain Benard
Sent: Tuesday, June 25, 2013 11:20 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] RE : Trying to restore a .backup file


Hi,
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 '2.9.2. Hard upgrade' in the
folowwing page is probably the solution :
 
http://www.postgis.org/documentation/manual-svn/postgis_installation.html#ha
rd_upgrade
have a nice day.
Alain. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130625/28e85bab/attachment.html>