Am 02.03.23 um 15:33 schrieb Tom Lane:
Holger Jakobs <holger@xxxxxxxxxx> writes: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.It shouldn't be different. However, this report would be trivially explained if your Windows machine has an %APPDATA%\postgresql\psqlrc.conf file that turns ON_ERROR_STOP on. You could try invoking psql with the -X command line switch to prevent reading that. regards, tom lane
BINGO! Thanks a lot. Sometimes you forget what you have done earlier. ;-) -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
