| 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 |
