[postgis-users] Error while trying a hard upgrade of postgis database

[Jayadevan M]

Hello all,

We are trying to upgrade from PostgreSQL (with GIS) from 8.2 to 9..1

1) When we execute postgis_restore.pl, we get an error.

D:\Applns\PostgreSQL\9.1\utils>postgis_restore.pl postgis.sql tnrsp_9.1 
d:\publicbackupnew_29june.backup -E=UNICODE > restore.log
Converting postgis.sql to ASCII on stdout...
  Reading list of functions to ignore...
  Writing manifest of things to read from dump file...
pg_restore: [archiver] input file does not appear to be a valid archive
D:\Applns\PostgreSQL\9.1\utils\postgis_restore.pl: pg_restore returned an 
error


2) But if we execute pg_restore from command prompt directly, it is 
working (loads all data except GIS. GIS data throws errors). A typical 
error would be 
"pg_restore: [archiver (db)] could not execute query: ERROR:  type 
"geometry" is only a shell
LINE 24:     the_geom geometry,
                      ^"


Version information -
Source PostgreSQL -
PostgreSQL 8.2.13 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 
(mingw-special)

Source GIS -
POSTGIS="1.1.6" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" 
USE_STATS (procs from 1.3.1 need upgrade)

Target PostgreSQL -
PostgreSQL 9.1.4, compiled by Visual C++ build 1500, 32-bit

Target GIS - 
"POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 
2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" 
LIBJSON="UNKNOWN" RASTER"


Any clues as to what we are doing wrong/how to fix this?

Thank you.
Jayadevan 






DISCLAIMER: 

"The information in this e-mail and any attachment is intended only for 
the person to whom it is addressed and may contain confidential and/or 
privileged material. If you have received this e-mail in error, kindly 
contact the sender and destroy all copies of the original communication. 
IBS makes no warranty, express or implied, nor guarantees the accuracy, 
adequacy or completeness of the information contained in this email or any 
attachment and is not liable for any errors, defects, omissions, viruses 
or for resultant loss or damage, if any, direct or indirect."




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120801/f4ed05b4/attachment.html>