psql terminates on first error - Mailing list pgsql-admin

From Holger Jakobs
Subject psql terminates on first error
Date
Msg-id 572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com
Whole thread Raw
Responses Re: psql terminates on first error  (Erik Wienhold <ewie@ewie.name>)
Re: psql terminates on first error  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


Attachment

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Create replication read only
Next
From: Erik Wienhold
Date:
Subject: Re: psql terminates on first error