Hi Paolo, If your sql is trying to use 'copy' command, I experencied that the superuser postgres can run it and stop the errors that you showed.
Humberto Ibanez 2015-12-22 4:39 GMT-02:00 Paolo Cavallini <cavall...@faunalia.it>: > 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 > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users