[postgis-users] Errors in loading table with geom which was produced with pg-dump

Shaozhong SHI shishaozhong at gmail.com
Thu Jan 23 09:23:31 PST 2020


I used pg_dump to dump a table with from.  Then, I used psql to load it to
another database, but it showed numerous errors.

Why does that happen?

On Thursday, 23 January 2020, <rmrodriguez at carto.com> wrote:

> On Thu, Jan 23, 2020 at 5:43 PM Shaozhong SHI <shishaozhong at gmail.com>
> wrote:
> >
> > Numerous errors were found when loading tables with psql.exe.  These
> tables were produced with pg_dump.exe.
>
> What are those errors and what commands did you run to dump and to
> restore the data?
> Also, does the target database has the same Postgis extensions
> installed? Which versions?
>
> --
> Raúl Marín Rodríguez
> carto.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200123/5c9c571b/attachment.html>


More information about the postgis-users mailing list