Re: pg_dump weirdness

I determined what the problem was this morning, there was one error
about a foreign key violation, which I did not really see earlier. so I
removed two foreign key constraints from the target table. The load then
worked properly, and some 600k records are now loaded.

On 11/6/2021 9:25 AM, MichaelDBA wrote:
> I think you are pointing to the wrong binaries.
>
> Use the absolute path to your pg_dump binary to make sure you are
> using the version you think you are using.  For example:
> /usr/pgsql-11/bin/pg_dump -h original_server -t
> original_schema.table_name -U user -W dbname > table_name.sql
>
> And for the target do the same for psql plus add the stop on error parm:
> /usr/pgsql-11/bin/psql -h target_server -U user newdbname -v
> ON_ERROR_STOP=1 < table_name.sql
>
> Regards,
> Michael Vitale
>
>
>