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

[Regina Obe]

Shao,

 

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.

 

Regards,

 

Shao 

 

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?

Hi,

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> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

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