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

Regina Obe lr at pcorp.us
Fri Jan 24 05:09:06 PST 2020



You are still not providing enough information.


We need the exact command you were using on pg_dump.  For example only if you are doing a plain text dump with pg_dump, can you use psql to load it.

A binary or tar dump needs to be loaded with pg_restore.  This piece of information is missing in your below explanation and could be why you are getting invalid commands.


Same goes for psql


From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Shaozhong SHI
Sent: Friday, January 24, 2020 6:44 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] Errors in loading table with geom which was produced with pg-dump


Hi, Raul Marin Rodriguez,


We are using PostgreSQL version 10.10 and postgis version 2.4.8 .


The command used for dump the data is pg_dump.exe.


The command used for import data is psql.exe.


The error message is full of invalid commands.






On Thu, 23 Jan 2020 at 17:28, <rmrodriguez at carto.com <mailto:rmrodriguez at carto.com> > wrote:

On Thu, Jan 23, 2020 at 6:23 PM Shaozhong SHI <shishaozhong at gmail.com <mailto:shishaozhong at gmail.com> > wrote:
> 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?


You are not providing any information to debug the issue. The
following information would help:
- Postgresql and Postgis version of both the source and target database.
- The command used to dump the data.
- The command used to import the data.
- The error messages.

Raúl Marín Rodríguez
carto.com <http://carto.com> 
postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200124/cdce6636/attachment.html>

More information about the postgis-users mailing list