[postgis-users] Errors restoring a db

Paolo Cavallini cavallini at faunalia.it
Mon Dec 21 22:39:21 PST 2015


Hi all,
I'm getting errors while restoring a db from a 1.5 dump to a
POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
LIBJSON="UNKNOWN" RASTER:

...
psql:geosisma_geo_restore.sql:8262499: invalid command \N
psql:geosisma_geo_restore.sql:8262500: invalid command \.
psql:geosisma_geo_restore.sql:8262504: ERROR:  syntax error at or near
"98424"
LINE 1: 98424 98424 98424 RT10000303152TO SENZA  F572
        ^
psql:geosisma_geo_restore.sql:8262507: invalid command \N
psql:geosisma_geo_restore.sql:8262508: invalid command \.
psql:geosisma_geo_restore.sql:8262513: ERROR:  syntax error at or near "1"
LINE 1: 1 12.9.2010 0106000020E6100000010000000103000000010000000500...
        ^
Any explanation or possible solution?
Thanks a lot.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html


More information about the postgis-users mailing list