psql terminates on first error

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема psql terminates on first error
Дата
Msg-id 572addf0-5116-cec0-77fb-9a0ba0161240@jakobs.com
обсуждение исходный текст
Ответы Re: psql terminates on first error
Re: psql terminates on first error
Список 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


Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Create replication read only
Следующее
От: Erik Wienhold
Дата:
Сообщение: Re: psql terminates on first error