| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | psql terminates on first error |
| Date: | 2023-03-02 11:53:19 |
| Message-ID: | 572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi everyone,
While trying to transfer data from one instance to another using
pg_dumpall and psql, the psql stopped on first error, causing pg_dumpall
to terminate as well.
This behaviour was seen on Windows (EDB installer), but is different on
Linux.
Only when using an option -c "\set ON_ERROR_STOP false" (plus -f - of
course to continue reading) psql continued after first error.
Not even the option -v ON_ERROR_STOP=0 helped.
Why is the behaviour between Linux and Windows different? This is not
reflected in the documentation.
Kind Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Wienhold | 2023-03-02 12:32:51 | Re: psql terminates on first error |
| Previous Message | Ron | 2023-03-01 22:00:31 | Re: Create replication read only |