Re: psql terminates on first error

Am 02.03.23 um 13:48 schrieb Thomas Kellerer:
> Holger Jakobs schrieb am 02.03.2023 um 13:44:
>>>> Only when using an option -c "\set ON_ERROR_STOP false" (plus -f - of
>>>> course to continue reading) psql continued after first error.
>>> Do you use PowerShell and pipe pg_dumpall into psql?  The first thing that
>>> comes to my mind when reading Postgres+Windows is that PowerShell up to
>>> version 5.1 converts stdout to UTF-16LE.  This already tripped me up in
>>> past with pg_dump and psql.
>> No, it was in cmd.exe or in bash
> I find using pipes with the Postgres command line tools on Windows unreliable
> in general (including cmd.exe). So if you did use redirection/pips, try without.
>
>
Whether I use pipes or writing stdout of pg_dumpall to a file and
reading back with psql from the file made no difference.

--

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012