Re: pg_dump weirdness - Mailing list pgsql-admin

From MichaelDBA
Subject Re: pg_dump weirdness
Date
Msg-id b3e479d6-0f1e-25fd-72bb-f0cdadff067b@sqlexec.com
Whole thread Raw
In response to pg_dump weirdness  (John Scalia <jayknowsunix@gmail.com>)
Responses Re: pg_dump weirdness
List pgsql-admin
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



pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: pg_dump weirdness
Next
From: dbatoCloud Solution
Date:
Subject: Looking for help to migrate Oracle PL SQL code to PGSQL code