Re: pg_dump weirdness

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: John Scalia <jayknowsunix(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump weirdness
Date: 2021-11-06 13:25:33
Message-ID: b3e479d6-0f1e-25fd-72bb-f0cdadff067b@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dbatoCloud Solution 2021-11-07 15:58:09 Looking for help to migrate Oracle PL SQL code to PGSQL code
Previous Message John Scalia 2021-11-06 02:41:42 Re: pg_dump weirdness