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

[Shaozhong SHI]

I do not know why.

What I am looking for is a robust and efficient way to do the following.

Make a copy of a table from a database.

Load it into another database.

It needs to work with tables with from.



On Friday, 24 January 2020, Regina Obe <lr at pcorp.us> wrote:

> 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> wrote:
>
> On Thu, Jan 23, 2020 at 6:23 PM Shaozhong SHI <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
> _______________________________________________
> 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/20200125/e9812636/attachment.html>