Error while trying a hard upgrade of postgis database
2012-08-01 06:39:39 GMT
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?
"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."
_______________________________________________ postgis-users mailing list postgis-users <at> postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users