[postgis-users] Errors restoring a db

Humberto Cereser Ibanez humberto at pastoraldacrianca.org.br
Tue Dec 22 05:21:02 PST 2015


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 <cavallini at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151222/612e8fb7/attachment.html>


More information about the postgis-users mailing list