From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: psql terminates on first error
Date: Thu, 2 Mar 2023 12:53:19 +0100
Message-ID: <572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com> (raw)
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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com/2-OpenPGP_signature)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: psql terminates on first error
In-Reply-To: <572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox